how to find the right most cell in a row with a value in it ?
The formula =lookup(9^9,3:3) works, with "3" being the row number.
questions:
1- what is the 9^9 ?
2- can i specify this for certian columns in a row? for example, look in row
B37:AH37 ?
"Shane Devenshire" wrote:
Depends on what you mean by "value"
=LOOKUP(9^9,3:3)
returns the last number in row 3
=LOOKUP(REPT("z",255),3:3)
returns the last text entery on row 3
=LOOKUP(2,1/(3:3<""),3:3)
returns the last non-blank cell.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Max" wrote:
I have a need to have cell with a formula or series of formulas, that can
find the right most cell in a specific row that has a value in it.
I tried various flavors of lookup but was not able to make this work.
any ideas?
|