how to find the right most cell in a row with a value in it ?
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?
|