Copying text from cells above

rambollet

New Member
Joined
Mar 12, 2002
Messages
18
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
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

rambollet

New Member
Joined
Mar 12, 2002
Messages
18
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
 

rambollet

New Member
Joined
Mar 12, 2002
Messages
18
Wow....Thanks Pablo! You had an answer for me before I could correct my question.
 

Forum statistics

Threads
1,144,329
Messages
5,723,736
Members
422,512
Latest member
MHau5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top