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
Bookmarks