Thread: Searching for #N/A
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Searching for #N/A
Some clarifications ..

The earlier array-entered:
=MATCH(TRUE,ISNUMBER(2:2),0)
will return the col number of the 1st occurrence of a real number

Adjusting arithmetically for it, array-entered:
=MATCH(TRUE,ISNUMBER(2:2),0)-1
will hence return the last occurrence of #N/A here, in your instance
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply With QuoteReply With Quote