LARGE IF OR question

[jcooooper]

Hello,

Currently I have the following formula which works great:

{=LARGE(IF($Z$1:$Z$10000="EQUITY",$AA$1:$AA$10000),J23)}

If I then wanted to include other candidates for large, with different text values than "EQUITY", all in column Z, how would I expand the above to include these?.

Been fiddling around with it but no dice.

Thanks!

 

[Marcelo Branco]

Yes, I think we are looking for two different outputs. The OR finds the nth-largest value in col AA range if there is any instance of "EQUITY" OR "BND" in col Z range.

Ah, now i understand what you did. I think we should wait that OP clarifies what he needs.

M.

 

[jcooooper]

Worked for me

	X​	Y​	Z​	AA​
1​	MyList​	Result​	ABS​	2​
2​	EQUITY​	20​	XXX​	3​
3​	ABS​		EQUITY​	2​
4​	BND​		EQUITY​	5​
5​	CMBS​		ZZZ​	50​
6​			BND​	4​
7​			BND​	20​
8​			CMBS​	12​
9​			zzz​	40​
10​			CMBS​	10​
11​

<tbody>
</tbody>

MyList --> X2:X5
J23 = 1 (to get the largest)

Array formula in Y2
=LARGE(IF(ISNUMBER(MATCH($Z$1:$Z$10000,MyList,0)),$AA$1:$AA$10000),J23)
Ctrl+Shift+Enter

M.

This works great, thanks so much!