formula

  • Thread starter Thread starter Dub
  • Start date Start date
D

Dub

i have a huge two column data, sample of it is:
name date
1 01-SEP-58
3 01-OCT-58
4 01-NOV-58
3 01-DEC-58
4 01-FEB-59
3 01-MAR-59

and i want to output the first date for each name,ie

1 01-SEP-58
3 01-OCT-58
4 01-NOV-58
thanks in advance.
 
Select column "name", then Data/Autofilter/Advanced filter, check Display
unique records only!

Regards,
Stefi


„Dub†ezt írta:
 
Back
Top