List based on formula

[CaptArt]

Excel version 2013. “Long time listener first time caller”
I have a list of dates in a column that is based on a formula. So the cells contain a formula to gather the dates. The column contains 200 rows, the dates listed have usually less than 25 dates. I would like to make a separate list without the blanks showing just the dates.

 

[myall_blues]

A picture or some sample data, preferably posted using XL2BB, would be helpful as it's not entirely clear what you need. For example, when you say 'without the blanks', does that imply that of the 200 rows only about 25 are dates and the rest are blank? Are there duplicate dates among the 200 and should they be kept or discarded? Is this a one-off or are you looking for a formula or VBA solution. As a one-off you could use Data->Data Tools->Remove duplicates.

 

[FormR]

Hi, maybe you can have a go at adapting something like this to your actual layout. The column A formula is just to generate test data for the formula in column C.

Book1
	A	B	C
1	Dates and Blanks		Dates no blanks
2			01/09/2016
3			01/12/2009
4			01/07/2017
5			01/11/2001
6	01/09/2016		01/10/2006
7			01/11/2011
8			01/02/2013
9
10	01/12/2009
11
12
13	01/07/2017
14	01/11/2001
15
16	01/10/2006
17	01/11/2011
18
19	01/02/2013
Sheet1

Cell Formulas
Range	Formula
A2:A19	A2	=IF(ISODD(RANDBETWEEN(1,10)),DATE(RANDBETWEEN(2000,2024),RANDBETWEEN(1,12),1),"")
C2:C19	C2	=IFERROR(INDEX($A$2:$A$20,AGGREGATE(15,6,(ROW($A$2:$A$20)-MIN(ROW($A$2:$A$20))+1)/ISNUMBER($A$2:$A$20),ROWS(C$2:C2))),"")