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

Assuming data in row2, in A2 across,
Array-entered (press CTRL+SHIFT+ENTER) in say B1:
=MATCH(TRUE,ISNUMBER(2:2),0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
On Feb 27, 1:26 pm, wrote:
I'm trying to create a formula that will tell me where the last
occurance of #N/A occurs in a table. If I have,

1 2 3 4 5
#N/A #N/A #N/A 2% 8%

I want a formula to tell me that the last occurance of #N/A is in
column 3, or that the first occurance of a real number is in column 4.
You can assume that the sets of #N/A will be contiguous.

Thank you.
-bgetson


Reply With QuoteReply With Quote