Hi all,
I have a sheet that has columns of numbers (lets say like below)
A1= 1500
A2= _
A3= _
Or
A1= _
A2= 1500
A3= _
They are all filled using formulas (lets say using a vlookup on another sheet).
They may sometimes be blank as shown in the examples above.
Only one will ever be populated...