I am trying to create a formula so that i can have one column which displays
the highest number or letter in any given row.
eg
1 - 2 - - 3
- - A B C -
- 1 - - - 2
etc.
Some cells are left blank (marked by dashes above). I would like a column
which displays the highest ranking (so 3 for the first row, C for the second
row and 2 for the third row) and automatically updates when new columns are
added.
Anyone know if this can be done?