Hi everyone,
It might be very easy but i couldnt figured it out,
I have 3 columns.
A) ID
B) Date
C) Index formula i want to build
There are same IDs as duplicate with different dates. I want to order dates from oldest to newest per unique ID, by giving them index numbers. At the end, my goal is keeping index 1s which is oldest date and deleting rest. Once I have the formula I will just filter 1s and remove the rest.
Attached example excel.
Thanks a lot
Orhan
Bookmarks