Put this in D2 and drag down (double click the cell handler)Now Column D needs to be copy Paste special value to column A.![]()
=IF(A2="",D3,A2)
Finally delete column D
Put this in D2 and drag down (double click the cell handler)Now Column D needs to be copy Paste special value to column A.![]()
=IF(A2="",D3,A2)
Finally delete column D
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks