Hi all, I've very recently started using Excel on a daily basis at work, and I would really appreciate some help with a problem that's been bugging me.
Columns A, B and C have numbers in them that go on for hundreds of rows. I'm trying to find a way of automatically showing the newest data in column D. The numbers written in column C are the most up do date, followed by the numbers in column B, then A.
The problem is some rows don't have numbers filled in for all columns. So what I want Excel to do for me is to always 'pick' the right-most/most up to date number that is listed (priority is C, then B, then A).
In other words, if the number in column C is absent, I want the number in column B to show in column D, and if B is empty too I want the number in column A to show.
How do I go about this?
Bookmarks