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

by

[ad_1]

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.

[ad_2]

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