formula
 

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.


--
Dub
------------------------------------------------------------------------
Dub's Profile: http://www.excelforum.com/member.php...fo&userid=7997
View this thread: http://www.excelforum.com/showthread...hreadid=535825

formula
 

Select column "name", then Data/Autofilter/Advanced filter, check Display
unique records only!

Regards,
Stefi


€žDub€� ezt Ã*rta:


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.


--
Dub
------------------------------------------------------------------------
Dub's Profile: http://www.excelforum.com/member.php...fo&userid=7997
View this thread: http://www.excelforum.com/showthread...hreadid=535825