List dates according to a scenario

[tsakta13ole]

Hi. I'm attaching my workbook. I have a column (column C) that has cells that are blank, has a value of 1 or a value of 2. I also have another column (column A) that has dates.
06/01/2000 1
07/01/2000
10/01/2000
11/01/2000 2
12/01/2000
13/01/2000
14/01/2000
17/01/2000
18/01/2000
19/01/2000
20/01/2000
21/01/2000
24/01/2000
25/01/2000
26/01/2000
27/01/2000
28/01/2000
31/01/2000
01/02/2000 1
02/02/2000
03/02/2000
04/02/2000 2
How, starting from cell D9, can I get the dates that have 1 or 2 in sequence?
In this case the result should be:
06/01/2000
11/01/2000
01/02/2000
04/02/2000

Hope you understand what I'm trying to do!
Thanks for any help!

[zbor]

Here, try this.

Please Login or Register  to view this content.

[tsakta13ole]

Thank you! This works!