Thread
:
how to find the right most cell in a row with a value in it ?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
how to find the right most cell in a row with a value in it ?
This finds the column num
=MATCH(LOOKUP(2,1/(14:14<""),14:14),14:14)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Max" wrote in message
...
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett