On Tue, 7 Jul 2009 08:20:01 -0700, Nelson
wrote:


I have an initial customer list A2:A1000 and the Dates each customer called
in with a question B2:B1000

from that list I have created (using advanced filtering) a unique List
(G2:G100)

A2:A1000 are of course not all unique customers, as the same customer could
of called in any number of times through the year.

However using my Unique list (G2: G100) I would like to get the first date
in which this customer called and nothing more and display it in the cells
H2:H100


I am using excel2007 but it needs to be backward compatible with 2003.

Any suggestions


If the dates in column B are sorted (ascending) then you may try this
in cell H2:

=VLOOKUP(G2,A$2:B$1000,2,FALSE)
Copy down to cell H100

If the dates in column B are not sorted then you may try this in cell
H2:

=MIN(IF(A$2:A$1000=G2,B$2:B$1000))
Copy down to cell H100.
Note: This is an array formula that has to be confirmed by
CTRL+SHIFT+ENTER rather than just ENTER.

Hope this helps / Lars-Åke