Large IF OR

[akmanti]

Hello

I have tried with Large IF OR, but it creates a boolean and Large dont care about that. I also tried with Sumproduct, however that only seems to function with 2 criterias that isnt OR but rather AND.

To simplify my question i will ask with the alphabet.

I have clipped my data in below.

I need to have a formula that takes the larges of the letters from column N, which is looked up in Column L and the corresponding Largest number in Column M is shown.

My formula that doesnt work: =Large(If(C:C=A:A;B:M);1)

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]x[/TD]
[TD]4[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]y[/TD]
[TD]7[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]z[/TD]
[TD]34[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]87[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]99[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]X[/TD]
[TD]78[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]65[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Z[/TD]
[TD]15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Y[/TD]
[TD]16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]88[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[AlanY]

it's an array formula,

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself

 

[tyija1995]

Not sure I am quite understanding this right but do the letters each represent a number in the adjacent column?

E.g.:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]a[/TD]
[TD]20[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]b[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]c[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]d[/TD]
[TD]23[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Do you want to see something like this? C1 returning the letter that corresponds to the largest number?

 

[DanteAmor]

Do you need something like this?

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >L</td><td >M</td><td >N</td><td >O</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td > </td><td >x</td><td style="text-align:right; ">4</td><td >x</td><td style="text-align:right; ">78</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td > </td><td >y</td><td style="text-align:right; ">7</td><td >Y</td><td style="text-align:right; ">20</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td > </td><td >z</td><td style="text-align:right; ">34</td><td >Z</td><td style="text-align:right; ">34</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td > </td><td >A</td><td style="text-align:right; ">87</td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td > </td><td >B</td><td style="text-align:right; ">99</td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td > </td><td >X</td><td style="text-align:right; ">78</td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td > </td><td >D</td><td style="text-align:right; ">65</td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td > </td><td >Z</td><td style="text-align:right; ">15</td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td > </td><td >Y</td><td style="text-align:right; ">16</td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td > </td><td >H</td><td style="text-align:right; ">88</td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td > </td><td >x</td><td style="text-align:right; ">60</td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td > </td><td >y</td><td style="text-align:right; ">20</td><td > </td><td > </td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >O1</td><td >=SUMPRODUCT(LARGE(($L$1:$L$14=N1)*($M$1:$M$14),1))</td></tr></table></td></tr></table>

 

[Marcelo Branco]

Not sure i understand what you need.
This?

[Table="class: grid"][tr][td="bgcolor: #DCE6F1"][/td][td="bgcolor: #DCE6F1"]

L​

[/td][td="bgcolor: #DCE6F1"]

M​

[/td][td="bgcolor: #DCE6F1"]

N​

[/td][td="bgcolor: #DCE6F1"]

O​

[/td][/tr]
[tr][td="bgcolor: #DCE6F1"]

1​

[/td][td]

x​

[/td][td]

4​

[/td][td]

x​

[/td][td]

Largest IF(L=N1:N3)​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

2​

[/td][td]

y​

[/td][td]

7​

[/td][td]

Y​

[/td][td]

78​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

3​

[/td][td]

z​

[/td][td]

34​

[/td][td]

Z​

[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

4​

[/td][td]

A​

[/td][td]

87​

[/td][td][/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

5​

[/td][td]

B​

[/td][td]

99​

[/td][td][/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

6​

[/td][td]

X​

[/td][td]

78​

[/td][td][/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

7​

[/td][td]

D​

[/td][td]

65​

[/td][td][/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

8​

[/td][td]

Z​

[/td][td]

15​

[/td][td][/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

9​

[/td][td]

Y​

[/td][td]

16​

[/td][td][/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

10​

[/td][td]

H​

[/td][td]

88​

[/td][td][/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

11​

[/td][td]

x​

[/td][td]

60​

[/td][td][/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

12​

[/td][td]

y​

[/td][td]

20​

[/td][td][/td][td][/td][/tr]
[/table]

Formula in O2
=AGGREGATE(14,6,M1:M12/ISNUMBER(MATCH(L1:L12,N1:N3,0)),1)

M.