View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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