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