help need on an index formula

[orhanceliloglu]

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

[bebo021999]

Cause date in column B is text "dd.mm.yyyy", there are 2 offers for cell C2:

1) Keep same format:

Please Login or Register  to view this content.

2) Convert text into real date (using Ctrl-H: Find what:. (dot) Replace with:/)
then using:

Please Login or Register  to view this content.