Where do you want the results to show? If you want them in another column
of the same row, then try this:

=IF(LEFT(A1,3)="XXX",B14)

Copy the formula down as needed.
I'm assuming the Date field is column B.

HTH,
Paul


"Rodrigo Ferreira" wrote in message
...
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