| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
a CHALLANGE using OR in an array formula
I'm using the following formula and now need to look for data matching CCYI
or CCYV. I've tried to use the OR but it returns a wrong answer. {=INDEX('E373'!$T$1:$T$2000,SMALL(IF(('E373'!$Y$1: $Y$2000='STATUS SHEET'!B3)*('E373'!$Q$1:$Q$2000="CCYI"),ROW('E373' !$T$1:$T$2000)),ROW('E373'!$T$1:$T$2000)))} I'd pull the rest of my hair out if I had any! Your help is greatly appreciated, O'C |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use array formula for three variables? | Excel Discussion (Misc queries) | |||
| Array formula weird result | Excel Discussion (Misc queries) | |||
| What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
| What instead of an array formula? | Excel Discussion (Misc queries) | |||
| SUM array formula question | Excel Worksheet Functions | |||
Threaded Mode
