Hello again.
Another plea for help. This is my scenario: I have several rows with arbitrary values (rows 1-5, from A to E), and at the bottom of each column (row 8) there are their corresponding 'index' values. I need to print, in the H column, the value of the corresponding cell in the same row with the highest bottom index value, ignoring the zeros (but printing zero in the H column if all the values of a row are zero). The fact that the row values are very similar isn't important at all.
See the attached .xls for an example:
1) In the first row, the value in H1 is -100 because the value of its 'index' is 40, and I need to ignore the 0 in B1 even if its index value is 50.
2) In the second row the value at H2 is 50, because its index value is 30 - again, I'm ignoring the row values equal to zero with index value 40 and 50.
3) In the third row, the value at H3 is 25, because the 25 in B3 has an index value of 50, the highest.
4) In the fourth row, the value at H4 is 0, because the row itself contains only zeros.
5) In the fifth row, the value at H5 is -40, because it has the highest index value (50).
I cannot create more columns, so I have to work with the preexisting values. I hope my explaination is clear.. and.. thanks in advance, again.
Bookmarks