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
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