Hi,
I have 10 columns and 10 rows of data. Not all of the 100 cells contain data.
I am looking for a formula that will return the value contained in the right most non zero or blank cell
Eg Row 1 =
1, 2, 4, 2, blank, 4, 3, blank, 0, blank
In Column 11 I want a formula that returns 3. i.e. it reads accross until it finds a value and returns it.
The target data is not neccesarily unique, the highest or the lowest.
Can anyone help (without nested IF statements as there may be up to 100 columns)
Thanks in advance
John