In N2: =--AND(K2<"",OR(H2<K2,I2<K2,J2<K2))
Copy down. Leave N1 empty.
(I took the liberty to add an additional logic check that col K is not
empty, which IMO makes your original OR intents more meaningful)
Then you could use in say, M2: =MATCH(1,N:N,0)
to get the "first" row number which satisfies the conditions
Above helps in some way? Click the YES button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"WhatsUp31415" wrote:
Looking at rows 2:4888, I want to find the first row number "x" in which
OR(Hx<Kx,Ix<Kx,Jx<Kx) is true.
How can I write that formula in Excel 2003?
I tried the following array formula, to no avail:
=MIN(IF(OR(H2:H4888<K2:K4888,I2:I4888<K2:K4888,J 2:J4888<K2:K4888),ROW(G2:G4888)))
making sure that the condition is first true in row 4.
But that formula always returns 2.
I confirmed that the formula is an array formula enclosed in curly braces.
Also, I filled a parallel column with =OR(H2<K2,I2<K2,J2<K2) and copied
down to confirm that the OR function first returns TRUE in row 4.