Thread: function - find first number in row 0, return cell column number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cate cate is offline
external usenet poster
  
Posts: 93
Default function - find first number in row 0, return cell column number

{=MATCH(CELL("col"),C2:H20,0)}


I'm trying to get the column number of the first cell in a row that
has a value 0.

I been trying things like above, but, I have been crushed.

Please help. Thank you.
Reply With QuoteReply With Quote