Is there a way that I can have Excel fill in the highlighted blank columns with the preceding value above.
I know that if I press F5 and select blanks, I can then press the equal sign and select the above cell and hit CTRL Enter.
This is fine for a few records, but I have many spanning across many columns.
I have also shown the desired outcome in my Sample spreadsheet.
If you're trying to populate column O then put this in O2 and drag down. You can use similar syntax in the other two columns
=IF(B2="",O1,B2)
Happy with my advice? Click on the * reputation button below
My apologies. The data in column 'O' is the desired outcome. There are just too many columns to enter the formula for each one.
I was hoping there was a Macro that could have made the job easier.
i'd just copy column O (after applying the formula) then paste back to column A as values
But if you want a macro try this
You can update for the other columns (or let me know if you can't and I'll update for you)
Please Login or Register to view this content.
Thank you very much Crooza. That's spot on!
I jumped the gun too quickly. Would you be so kind as to update the other columns so I can understand the code please
Just repeat for columns C/D and E/F like this
Please Login or Register to view this content.
Thank you. I thought that might be the case. Just wanted to confirm. Thank you once again for your guidance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks