Previous Topic Next Topic

Need help with Excel

Closed
HOUSTONGUY Posts 1 Registration date Thursday September 16, 2010 Status Member Last seen September 16, 2010 - Sep 16, 2010 at 09:15 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 16, 2010 at 08:47 PM
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!
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 16, 2010 at 08:47 PM
this expression

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

is not clear. explain with example
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response