Retrieve all the dates of XXX without macro
Well you could create a helper column and enter the formula
=IF(A2="XXX_1",B2,"") and then filter out the blank rows on that third column?
Dave
--
Brevity is the soul of wit.
"Rodrigo Ferreira" wrote:
I'll try to explain what I want:
Sheet1
Name Date
XXX_1 01/01/2007
XXX_2 02/01/2007
XXX_3 03/01/2007
XXX_1 04/01/2007
....
Sheet2:
I would like to retrieve all the dates of XXX_1 without macro. Is it
possible?
--
Rodrigo Ferreira
|