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