| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find first row where condition is true?
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Rows If Condition True | Excel Worksheet Functions | |||
| result if a condition is NOT true? | Excel Worksheet Functions | |||
| Continually check if condition is true in VBA | Excel Discussion (Misc queries) | |||
| TRUE condition??? | Excel Discussion (Misc queries) | |||
| How Do I Hide A Row (if a condition is true) using a Macro ? | Excel Worksheet Functions | |||
Threaded Mode
