ExcelBanter - formula to mark last and first row

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula to mark last and first row (https://www.excelbanter.com/excel-discussion-misc-queries/447243-formula-mark-last-first-row.html)

Legolas

formula to mark last and first row

1 Attachment(s)

Dear all,

I got a task as attached to find only the first and last trip of each vehicles which drove on one day

I need to have in C the first trip on each day and mark it as "X"
and then in D last trip of the same vehicle at the same day as "Y".

what formulas do i need in C and D ?

thanks for any help

All times are GMT +1. The time now is 09:42 PM.