View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vasil Ivanov Vasil Ivanov is offline
external usenet poster
 
Posts: 3
Default How to:Find the row of the first cell not equal to several values

I have a column with values "OB" followed by several values "IB" and I wat to
see if there is a value different from these and return its row.

that's my array function "={MIN(IF(AND(C3:C500<"OB",
C3:C500<"IB"),ROW(C3:C500),12345678)}" but it's not working correctly

However, when I want to find the first value different from "OB"(in my case
thats the row of the first "IB" value) I use the function:

"{=MIN(IF(C3:C500<"OB",ROW(C3:C500), 12345678)}" and it's working correctly.

Can anybody tell me what's wrong with the first formula and what do I have
to change in it?