[Solved] Identify and output first and last records by group [closed]

Question

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, the content copied to another sheet and parsed with Text to Columns, pipe delimited and suitable formatting.

Accepted Answer

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, the content copied to another sheet and parsed with Text to Columns, pipe delimited and suitable formatting.