Copying text from cells above

[rambollet]

What formula will return the value of the first cell above it that contains data? For example if the worksheet has:<pre>Abby 01/02/02 Green
Blue
01/03/02 Red
01/04/02 Orange
Beth 02/04/02 Violet
Black</pre>


I would like the formula to produce:<pre>Abby 01/02/02 Green
Abby 02/02/02 Blue
Abby 01/03/02 Red
Abby 01/04/02 Orange
Beth 02/04/02 Violet
Beth 02/04/02 Black</pre>
This message was edited by Juan Pablo G. on 2002-10-17 10:38

 

[Juan Pablo González]

This

Abby 02/02/02 Blue

should be

Abby 01/02/02 Blue

right ?

 

[Juan Pablo González]

Try this

Libro1
	A	B	C	D	E	F	G
1	Example				Results
2	Abby	01/02/2002	Green		Abby	01/02/2002	Green
3			Blue		Abby	01/02/2002	Blue
4		01/03/2002	Red		Abby	01/03/2002	Red
5		01/04/2002	Orange		Abby	01/04/2002	Orange
6	Beth	02/04/2002	Violet		Beth	02/04/2002	Violet
7			Black		Beth	02/04/2002	Black
Hoja2

 

[rambollet]

OK...formatting wasn't much help. How about if Cell Values are as follows:
A1=Abby
A2 is blank
A3 is blank
A4=Beth
A5 is blank
B1=1/02/02
B2 is blank
B3=1/03/02
B4=01/05/02
B5 is blank

I need formula to return:
A1= Abby
A2= Abby
A3= Abby
A4=Beth
A5=Beth
B1=01/02/02
B2=01/02/02
B3=01/03/02
B4=01/05/02
B5=01/05/02

 

[Juan Pablo González]

Just in case, see my reply above.

 

[rambollet]

Wow....Thanks Pablo! You had an answer for me before I could correct my question.