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