Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy Data From Filled to Empty Cells
Hi All,
I am facing a problem. I have a long list of values having multiple columns. There is a column which is used for the persons name who deals with that product. the sample for that column is as: Ben Miler Wondwossen Saadi Lara Farah Alex Adam I want to copy the values from Upper Filled cell to all the empty cells below, in above case Lara in all 3 empty cells above Farah. can anybody plese help me in this regard. currently i am using =IF(A2="",A1,A2) it is Ok if there is only one empty cell, but if there are more than one, it fails. any other formula is there? lokking forward t\o your responses. thanks and regard. -- Sheikh Saadi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy empty cells from one workbook to another - Code | Excel Discussion (Misc queries) | |||
Macro that copy page to page just some filled cells | Excel Discussion (Misc queries) | |||
REPOST: How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |