[Solved] Identify and output first and last records by group [closed]
If able to sort by date within task and to ensure that any subsequent sheet starts at a new task and the last ColumnB and ColumnC values on each sheet are repeated in the row immediately below, a formula might suit: =IF(A1<>A2,A1&”|”&VLOOKUP(A1,A:B,2,0)&”|”&C1&”|”&B2-VLOOKUP(A1,A:B,2,0),””) with the columns where the formula output is evident filtered to exclude blanks, … Read more