ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 965
- Office Version
- 365
- 2010
- Platform
- Windows
I have the following formula for just 1 criteria but I was trying to figure out how to do this with 2 criteria
=INDEX($AL20:$AL1019,AGGREGATE(15,6,(ROW($AL20:$AL1019)-ROW($AL20)+1)/($BT20:$BT$1019=7),1))
The above formula indexes the row $AL20:$AL$1019 that contain the row numbers 20 through 1019
$BT20:$BT$1019 contain values 6, 7, 8, 9, 10, 11, 12
The 1 at the end of the formula finds the row number for the 1st occurrence of the value 7 from cell range $BT$20:$BT$1019
Is it possible to add to the formula that will calculate a 2nd criteria from cell range $BV$20:$BV$1019 that contain the value 3
Thank you in advance!!
=INDEX($AL20:$AL1019,AGGREGATE(15,6,(ROW($AL20:$AL1019)-ROW($AL20)+1)/($BT20:$BT$1019=7),1))
The above formula indexes the row $AL20:$AL$1019 that contain the row numbers 20 through 1019
$BT20:$BT$1019 contain values 6, 7, 8, 9, 10, 11, 12
The 1 at the end of the formula finds the row number for the 1st occurrence of the value 7 from cell range $BT$20:$BT$1019
Is it possible to add to the formula that will calculate a 2nd criteria from cell range $BV$20:$BV$1019 that contain the value 3
Thank you in advance!!