Need help with Excel

Closed
Report
Posts
1
Registration date
Thursday September 16, 2010
Status
Member
Last seen
September 16, 2010
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello all,

I need help in formulating a spreadsheet. I have 10 columns, with data. I need to compare column 1 to column 10. But if column 10 is 0, go to column 9. If column 9 is 0, go to column 8, and so on until one of the columns has data other than 0. After that, it should display either "greater than, less than, or same". Thanks for helping!

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
this expression

After that, it should display either "greater than, less than, or same".

is not clear. explain with example