formula

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.
 
S

Stefi

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

Regards,
Stefi


„Dub†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 dimensional date sort 2
How to getting text labels to show up in scatter chart. 0
Help with time function 7
Suming Up Time over the course of days 1
Distributing cell value (not text-to-columns) 7
lookup help. lookup result based on data in 2 columns 3
roblems with creating my pivottable because of the way my data is structured 0
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0

Top