G
Guest
Guest
I have a row of columns numbered 1-10 (Say A1-A10) and the cells below may have information in depending on the result of another formula. How can I get Excel to look at the information in row B, starting with column A10? If there is no entry in B10 I need it to look at B9, and so on until it finds a cell with some information in.
Hope this makes sense to someone! Please help!
Thanks.
Hope this makes sense to someone! Please help!
Thanks.