View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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?