Finding Date Rows and Filling Labels

[copyboy007]

Can a second column be added that finds the row with a date, then creates an entry matching the cell from the first row after the date above it?

Column A
-----------
1234
xyz
$5678
1/1/20
100908
abc
def $5577
$123
10/17/05

Column B
-----------
1234
1234
1234
1234
100908
100908
100908
100908
100908

 

[DanteAmor]

Try this

The text "Data" in the formula should be changed to what you have in cell A1, in my example in A1 I put "Data", so in the formula I have "Data"

Dante Amor
	A	B
1	Data	Reference
2	1234	1234
3	xyz	1234
4	$5,678	1234
5	01/01/2020	1234
6	100908	100908
7	abc	100908
8	def $5577	100908
9	$123	100908
10	17/10/2005	100908
11
12
Hoja6

Cell Formulas
Range	Formula
B2:B10	B2	=IF(OR(A1="Data",LEFT(CELL("formato",A1))="D"),A2,B1)

 

[copyboy007]

Changing 'formato' to 'format', the formula works for the given sample data.

I tried applying it to the raw data, but what needs to be changed when there's other data in the same cell as the date?

For example,

Column A
-----------
1234 2020202020
xyz
$5678
1/1/20 $101010
100908 3030303030
abc
def $5577
$123
10/17/05 $4040404040

 

[DanteAmor]

Changing 'formato' to 'format', the formula works

My mistake, failed to translate that part.

1/1/20 $101010

The formula is for a date, your example is now a text.
Will you have more scenarios to consider?
You could put your examples using XL2BB tool and most importantly, what result do you expect.
Could it be with a macro?