Comparing Values in Multiple Rows and Bringing Back Chosen Values

[gazgazgazgaz]

Hi Folks,

Looking for some assistance with this scenario.

[TABLE="width: 1346"]
<colgroup><col span="5"><col></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD]Post[/TD]
[TD]Person[/TD]
[TD]Check Needed[/TD]
[TD]Check in Place[/TD]
[TD]What I want to see[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]WW1[/TD]
[TD]Bob[/TD]
[TD]Level 1[/TD]
[TD]None[/TD]
[TD]Highest Check Needed (Across ALL posts) for Bob is Level 2 and Highest Level in place is Level 1.
Action to be taken.[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]WW1[/TD]
[TD]Bob[/TD]
[TD]Level 1[/TD]
[TD]Level 1[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]WW2[/TD]
[TD]Bob[/TD]
[TD]Level 2[/TD]
[TD]Level 1[/TD]
[/TR]
[TR]
[TD]
2555[/TD]
[TD]
DR1[/TD]
[TD]
Jimmy[/TD]
[TD]
Level 3[/TD]
[TD]
Level 2
[/TD]
[TD]
Highest Check Needed (Across ALL posts) for Jimmy is Level 3 and Highest Level in place is Level 2.
Action to be taken.[/TD]
[/TR]
[TR]
[TD]2555[/TD]
[TD]DR1[/TD]
[TD]Jimmy[/TD]
[TD]Level 3[/TD]
[TD]Level 2[/TD]
[/TR]
[TR]
[TD]
3698[/TD]
[TD]
TY6[/TD]
[TD]
Angela[/TD]
[TD]
Level 1[/TD]
[TD]
None[/TD]
[TD]Highest Check Needed (Across ALL posts) for Angela is Level 3 and Highest Level in place is Level 3.
No action to be taken.[/TD]
[/TR]
[TR]
[TD]3698[/TD]
[TD]TY8[/TD]
[TD]Angela[/TD]
[TD]Level 3[/TD]
[TD]Level 3[/TD]
[/TR]
[TR]
[TD]
4011[/TD]
[TD]
EE3[/TD]
[TD]
Xavier[/TD]
[TD]
Level 3[/TD]
[TD]
None[/TD]
[TD]Highest Check Needed (Across ALL posts) for Xavier is Level 3 and Highest Level in place is Level 2.
Action to be taken.[/TD]
[/TR]
[TR]
[TD]4011[/TD]
[TD]EE4[/TD]
[TD]Xavier[/TD]
[TD]Level 3[/TD]
[TD]Level 1[/TD]
[/TR]
[TR]
[TD]4011[/TD]
[TD]EE4[/TD]
[TD]Xavier[/TD]
[TD]Level 3[/TD]
[TD]Level 2[/TD]
[/TR]
</tbody>[/TABLE]

Unique ID will be the (ID) but they can have multiple differences in the other fields.

I want to bring back the desired highest check required and highest check in place values for each employee (across multiple rows) but display results in one row.

I've thought about assigning scores to the values and summing or a pivot table but I can't decipher the best options (if Excel is the best solution!)

Thank you.

Gary.

 

[oldbrewer]

[TABLE="width: 726"]
<colgroup><col span="3"><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD]Post[/TD]
[TD]Person[/TD]
[TD]Check Needed[/TD]
[TD]Check in Place[/TD]
[TD]HELPER1[/TD]
[TD]HELPER2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1234[/TD]
[TD]WW1[/TD]
[TD]Bob[/TD]
[TD]Level 1[/TD]
[TD]None[/TD]
[TD]1[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1234[/TD]
[TD]WW1[/TD]
[TD]Bob[/TD]
[TD]Level 1[/TD]
[TD]Level 1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1234[/TD]
[TD]WW2[/TD]
[TD]Bob[/TD]
[TD]Level 2[/TD]
[TD]Level 1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2555[/TD]
[TD]DR1[/TD]
[TD]Jimmy[/TD]
[TD]Level 3[/TD]
[TD]Level 2[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2555[/TD]
[TD]DR1[/TD]
[TD]Jimmy[/TD]
[TD]Level 3[/TD]
[TD]Level 2[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3698[/TD]
[TD]TY6[/TD]
[TD]Angela[/TD]
[TD]Level 1[/TD]
[TD]None[/TD]
[TD]1[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3698[/TD]
[TD]TY8[/TD]
[TD]Angela[/TD]
[TD]Level 3[/TD]
[TD]Level 3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4011[/TD]
[TD]EE3[/TD]
[TD]Xavier[/TD]
[TD]Level 3[/TD]
[TD]None[/TD]
[TD]3[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4011[/TD]
[TD]EE4[/TD]
[TD]Xavier[/TD]
[TD]Level 3[/TD]
[TD]Level 1[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4011[/TD]
[TD]EE4[/TD]
[TD]Xavier[/TD]
[TD]Level 3[/TD]
[TD]Level 2[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]check needed[/TD]
[TD]check in place[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bob[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Jimmy[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Angela[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Xavier[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]the 2 against Bob is obtained by[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]=SUMPRODUCT(MAX(($C$2:$C$11=C21)*$F$2:$F$11))[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Legacy 396030]

I hope this helps!

Sheet1

	A	B	C	D	E	F	G	H	I	J	K
		Comparing Values in Multiple Rows and Bringing Back Chosen Values

<colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 85.6px;"> <col style="width: 85.6px;"> <col style="width: 85.6px;"> <col style="width: 155.2px;"> <col style="width: 183.2px;"> <col style="width: 85.6px;"> <col style="width: 85.6px;"> <col style="width: 85.6px;"> <col style="width: 85.6px;"> <col style="width: 215.2px;"> <col style="width: 256px;"></colgroup> <tbody>
[TD="bgcolor: #CACACA, align: center"]1[/TD]
[TD="bgcolor: #99CCFF, colspan: 5, align: center"]Data Table[/TD]

[TD="bgcolor: #99CCFF, colspan: 5, align: center"]Maximum Values[/TD]

[TD="bgcolor: #CACACA, align: center"]2[/TD]
[TD="align: center"]ID[/TD]
[TD="align: center"]Post[/TD]
[TD="align: center"]Person[/TD]
[TD="align: center"]Check Needed Level[/TD]
[TD="align: center"]Check Level in Place[/TD]

[TD="align: center"]ID[/TD]
[TD="align: center"]Post[/TD]
[TD="align: center"]Person[/TD]
[TD="align: center"]Highest Check Needed Level[/TD]
[TD="align: center"]Highest Check Level in Place[/TD]

[TD="bgcolor: #CACACA, align: center"]3[/TD]
[TD="align: center"]1234[/TD]
[TD="align: center"]WW1[/TD]
[TD="align: center"]Bob[/TD]
[TD="align: center"]1.00[/TD]
[TD="align: center"]44.00[/TD]

[TD="bgcolor: #FFFF00, align: center"]2555[/TD]
[TD="bgcolor: #FFFF00, align: center"]DR1[/TD]
[TD="bgcolor: #FFFF00, align: center"]Jimmy[/TD]
[TD="bgcolor: #FFFF00, align: center"]5.00[/TD]
[TD="bgcolor: #FFFF00, align: center"]8.00[/TD]

[TD="bgcolor: #CACACA, align: center"]4[/TD]
[TD="align: center"]1234[/TD]
[TD="align: center"]WW2[/TD]
[TD="align: center"]Bob[/TD]
[TD="align: center"]8.00[/TD]
[TD="align: center"]1.00[/TD]

[TD="align: center"]2555[/TD]
[TD="align: center"]DR2[/TD]
[TD="align: center"]Jimmy[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]

[TD="bgcolor: #CACACA, align: center"]5[/TD]
[TD="align: center"]1234[/TD]
[TD="align: center"]WW3[/TD]
[TD="align: center"]Bob[/TD]
[TD="align: center"]7.00[/TD]
[TD="align: center"]1.00[/TD]

[TD="align: center"]1234[/TD]
[TD="align: center"]WW1[/TD]
[TD="align: center"]Bob[/TD]
[TD="align: center"]1.00[/TD]
[TD="align: center"]44.00[/TD]

[TD="bgcolor: #CACACA, align: center"]6[/TD]
[TD="bgcolor: #FFFF00, align: center"]2555[/TD]
[TD="bgcolor: #FFFF00, align: center"]DR1[/TD]
[TD="bgcolor: #FFFF00, align: center"]Jimmy[/TD]
[TD="bgcolor: #FFFF00, align: center"]5.00[/TD]
[TD="bgcolor: #FFFF00, align: center"]2.00[/TD]

[TD="align: center"]1234[/TD]
[TD="align: center"]WW2[/TD]
[TD="align: center"]Bob[/TD]
[TD="align: center"]8.00[/TD]
[TD="align: center"]1.00[/TD]

[TD="bgcolor: #CACACA, align: center"]7[/TD]
[TD="bgcolor: #FFFF00, align: center"]2555[/TD]
[TD="bgcolor: #FFFF00, align: center"]DR1[/TD]
[TD="bgcolor: #FFFF00, align: center"]Jimmy[/TD]
[TD="bgcolor: #FFFF00, align: center"]3.00[/TD]
[TD="bgcolor: #FFFF00, align: center"]8.00[/TD]

[TD="align: center"]1234[/TD]
[TD="align: center"]WW3[/TD]
[TD="align: center"]Bob[/TD]
[TD="align: center"]7.00[/TD]
[TD="align: center"]1.00[/TD]

[TD="bgcolor: #CACACA, align: center"]8[/TD]
[TD="align: center"]3698[/TD]
[TD="align: center"]TY6[/TD]
[TD="align: center"]Angela[/TD]
[TD="align: center"]1.00[/TD]
[TD="align: center"]0.00[/TD]

[TD="align: center"]3698[/TD]
[TD="align: center"]TY6[/TD]
[TD="align: center"]Angela[/TD]
[TD="align: center"]1.00[/TD]
[TD="align: center"]0.00[/TD]

[TD="bgcolor: #CACACA, align: center"]9[/TD]
[TD="align: center"]3698[/TD]
[TD="align: center"]TY8[/TD]
[TD="align: center"]Angela[/TD]
[TD="align: center"]2.00[/TD]
[TD="align: center"]3.00[/TD]

[TD="align: center"]3698[/TD]
[TD="align: center"]TY8[/TD]
[TD="align: center"]Angela[/TD]
[TD="align: center"]2.00[/TD]
[TD="align: center"]3.00[/TD]

[TD="bgcolor: #CACACA, align: center"]10[/TD]
[TD="align: center"]4011[/TD]
[TD="align: center"]EE3[/TD]
[TD="align: center"]Xavier[/TD]
[TD="align: center"]3.00[/TD]
[TD="align: center"]0.00[/TD]

[TD="align: center"]4011[/TD]
[TD="align: center"]EE3[/TD]
[TD="align: center"]Xavier[/TD]
[TD="align: center"]3.00[/TD]
[TD="align: center"]0.00[/TD]

[TD="bgcolor: #CACACA, align: center"]11[/TD]
[TD="align: center"]4011[/TD]
[TD="align: center"]EE4[/TD]
[TD="align: center"]Xavier[/TD]
[TD="align: center"]3.00[/TD]
[TD="align: center"]1.00[/TD]

[TD="align: center"]4011[/TD]
[TD="align: center"]EE4[/TD]
[TD="align: center"]Xavier[/TD]
[TD="align: center"]3.00[/TD]
[TD="align: center"]1.00[/TD]

[TD="bgcolor: #CACACA, align: center"]12[/TD]
[TD="align: center"]4011[/TD]
[TD="align: center"]EE5[/TD]
[TD="align: center"]Xavier[/TD]
[TD="align: center"]5.00[/TD]
[TD="align: center"]2.00[/TD]

[TD="align: center"]4011[/TD]
[TD="align: center"]EE5[/TD]
[TD="align: center"]Xavier[/TD]
[TD="align: center"]5.00[/TD]
[TD="align: center"]2.00[/TD]

[TD="bgcolor: #CACACA, align: center"]13[/TD]

[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]

[TD="bgcolor: #CACACA, align: center"]14[/TD]

[TD="bgcolor: #CACACA, align: center"]15[/TD]

[TD="bgcolor: #99CCFF, colspan: 5, align: center"]Minimum Values[/TD]

[TD="bgcolor: #CACACA, align: center"]16[/TD]

[TD="align: center"]ID[/TD]
[TD="align: center"]Post[/TD]
[TD="align: center"]Person[/TD]
[TD="align: center"]Highest Check Needed Level[/TD]
[TD="align: center"]Highest Check Level in Place[/TD]

[TD="bgcolor: #CACACA, align: center"]17[/TD]

[TD="bgcolor: #FFFF00, align: center"]2555[/TD]
[TD="bgcolor: #FFFF00, align: center"]DR1[/TD]
[TD="bgcolor: #FFFF00, align: center"]Jimmy[/TD]
[TD="bgcolor: #FFFF00, align: center"]3.00[/TD]
[TD="bgcolor: #FFFF00, align: center"]2.00[/TD]

[TD="bgcolor: #CACACA, align: center"]18[/TD]

[TD="align: center"]2555[/TD]
[TD="align: center"]DR2[/TD]
[TD="align: center"]Jimmy[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]

[TD="bgcolor: #CACACA, align: center"]19[/TD]

[TD="align: center"]1234[/TD]
[TD="align: center"]WW1[/TD]
[TD="align: center"]Bob[/TD]
[TD="align: center"]1.00[/TD]
[TD="align: center"]44.00[/TD]

[TD="bgcolor: #CACACA, align: center"]20[/TD]

[TD="align: center"]1234[/TD]
[TD="align: center"]WW2[/TD]
[TD="align: center"]Bob[/TD]
[TD="align: center"]8.00[/TD]
[TD="align: center"]1.00[/TD]

[TD="bgcolor: #CACACA, align: center"]21[/TD]

[TD="align: center"]1234[/TD]
[TD="align: center"]WW3[/TD]
[TD="align: center"]Bob[/TD]
[TD="align: center"]7.00[/TD]
[TD="align: center"]1.00[/TD]

[TD="bgcolor: #CACACA, align: center"]22[/TD]

[TD="align: center"]3698[/TD]
[TD="align: center"]TY6[/TD]
[TD="align: center"]Angela[/TD]
[TD="align: center"]1.00[/TD]
[TD="align: center"]0.00[/TD]

[TD="bgcolor: #CACACA, align: center"]23[/TD]

[TD="align: center"]3698[/TD]
[TD="align: center"]TY8[/TD]
[TD="align: center"]Angela[/TD]
[TD="align: center"]2.00[/TD]
[TD="align: center"]3.00[/TD]

[TD="bgcolor: #CACACA, align: center"]24[/TD]

[TD="align: center"]4011[/TD]
[TD="align: center"]EE3[/TD]
[TD="align: center"]Xavier[/TD]
[TD="align: center"]3.00[/TD]
[TD="align: center"]0.00[/TD]

[TD="bgcolor: #CACACA, align: center"]25[/TD]

[TD="align: center"]4011[/TD]
[TD="align: center"]EE4[/TD]
[TD="align: center"]Xavier[/TD]
[TD="align: center"]3.00[/TD]
[TD="align: center"]1.00[/TD]

[TD="bgcolor: #CACACA, align: center"]26[/TD]

[TD="align: center"]4011[/TD]
[TD="align: center"]EE5[/TD]
[TD="align: center"]Xavier[/TD]
[TD="align: center"]5.00[/TD]
[TD="align: center"]2.00[/TD]

[TD="bgcolor: #CACACA, align: center"]27[/TD]

[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula J3 {=MAX(IF($A$3:$A$13=$G3,IF($B$3:$B$13=$H3,IF($C$3:$C$13=$I3,D$3:D$13))))} K3 {=MAX(IF($A$3:$A$13=$G3,IF($B$3:$B$13=$H3,IF($C$3:$C$13=$I3,E$3:E$13))))} J4 {=MAX(IF($A$3:$A$13=$G4,IF($B$3:$B$13=$H4,IF($C$3:$C$13=$I4,D$3:D$13))))} K4 {=MAX(IF($A$3:$A$13=$G4,IF($B$3:$B$13=$H4,IF($C$3:$C$13=$I4,E$3:E$13))))} J5 {=MAX(IF($A$3:$A$13=$G5,IF($B$3:$B$13=$H5,IF($C$3:$C$13=$I5,D$3:D$13))))} K5 {=MAX(IF($A$3:$A$13=$G5,IF($B$3:$B$13=$H5,IF($C$3:$C$13=$I5,E$3:E$13))))} J6 {=MAX(IF($A$3:$A$13=$G6,IF($B$3:$B$13=$H6,IF($C$3:$C$13=$I6,D$3:D$13))))} K6 {=MAX(IF($A$3:$A$13=$G6,IF($B$3:$B$13=$H6,IF($C$3:$C$13=$I6,E$3:E$13))))} J7 {=MAX(IF($A$3:$A$13=$G7,IF($B$3:$B$13=$H7,IF($C$3:$C$13=$I7,D$3:D$13))))} K7 {=MAX(IF($A$3:$A$13=$G7,IF($B$3:$B$13=$H7,IF($C$3:$C$13=$I7,E$3:E$13))))} J8 {=MAX(IF($A$3:$A$13=$G8,IF($B$3:$B$13=$H8,IF($C$3:$C$13=$I8,D$3:D$13))))} K8 {=MAX(IF($A$3:$A$13=$G8,IF($B$3:$B$13=$H8,IF($C$3:$C$13=$I8,E$3:E$13))))} J9 {=MAX(IF($A$3:$A$13=$G9,IF($B$3:$B$13=$H9,IF($C$3:$C$13=$I9,D$3:D$13))))} K9 {=MAX(IF($A$3:$A$13=$G9,IF($B$3:$B$13=$H9,IF($C$3:$C$13=$I9,E$3:E$13))))} J10 {=MAX(IF($A$3:$A$13=$G10,IF($B$3:$B$13=$H10,IF($C$3:$C$13=$I10,D$3:D$13))))} K10 {=MAX(IF($A$3:$A$13=$G10,IF($B$3:$B$13=$H10,IF($C$3:$C$13=$I10,E$3:E$13))))} J11 {=MAX(IF($A$3:$A$13=$G11,IF($B$3:$B$13=$H11,IF($C$3:$C$13=$I11,D$3:D$13))))} K11 {=MAX(IF($A$3:$A$13=$G11,IF($B$3:$B$13=$H11,IF($C$3:$C$13=$I11,E$3:E$13))))} J12 {=MAX(IF($A$3:$A$13=$G12,IF($B$3:$B$13=$H12,IF($C$3:$C$13=$I12,D$3:D$13))))} K12 {=MAX(IF($A$3:$A$13=$G12,IF($B$3:$B$13=$H12,IF($C$3:$C$13=$I12,E$3:E$13))))} J13 {=MAX(IF($A$3:$A$13=$G13,IF($B$3:$B$13=$H13,IF($C$3:$C$13=$I13,D$3:D$13))))} K13 {=MAX(IF($A$3:$A$13=$G13,IF($B$3:$B$13=$H13,IF($C$3:$C$13=$I13,E$3:E$13))))} J17 {=MIN(IF($A$3:$A$13=$G17,IF($B$3:$B$13=$H17,IF($C$3:$C$13=$I17,D$3:D$13))))} K17 {=MIN(IF($A$3:$A$13=$G17,IF($B$3:$B$13=$H17,IF($C$3:$C$13=$I17,E$3:E$13))))} J18 {=MIN(IF($A$3:$A$13=$G18,IF($B$3:$B$13=$H18,IF($C$3:$C$13=$I18,D$3:D$13))))} K18 {=MIN(IF($A$3:$A$13=$G18,IF($B$3:$B$13=$H18,IF($C$3:$C$13=$I18,E$3:E$13))))} J19 {=MIN(IF($A$3:$A$13=$G19,IF($B$3:$B$13=$H19,IF($C$3:$C$13=$I19,D$3:D$13))))} K19 {=MIN(IF($A$3:$A$13=$G19,IF($B$3:$B$13=$H19,IF($C$3:$C$13=$I19,E$3:E$13))))} J20 {=MIN(IF($A$3:$A$13=$G20,IF($B$3:$B$13=$H20,IF($C$3:$C$13=$I20,D$3:D$13))))} K20 {=MIN(IF($A$3:$A$13=$G20,IF($B$3:$B$13=$H20,IF($C$3:$C$13=$I20,E$3:E$13))))} J21 {=MIN(IF($A$3:$A$13=$G21,IF($B$3:$B$13=$H21,IF($C$3:$C$13=$I21,D$3:D$13))))} K21 {=MIN(IF($A$3:$A$13=$G21,IF($B$3:$B$13=$H21,IF($C$3:$C$13=$I21,E$3:E$13))))} J22 {=MIN(IF($A$3:$A$13=$G22,IF($B$3:$B$13=$H22,IF($C$3:$C$13=$I22,D$3:D$13))))} K22 {=MIN(IF($A$3:$A$13=$G22,IF($B$3:$B$13=$H22,IF($C$3:$C$13=$I22,E$3:E$13))))} J23 {=MIN(IF($A$3:$A$13=$G23,IF($B$3:$B$13=$H23,IF($C$3:$C$13=$I23,D$3:D$13))))} K23 {=MIN(IF($A$3:$A$13=$G23,IF($B$3:$B$13=$H23,IF($C$3:$C$13=$I23,E$3:E$13))))} J24 {=MIN(IF($A$3:$A$13=$G24,IF($B$3:$B$13=$H24,IF($C$3:$C$13=$I24,D$3:D$13))))} K24 {=MIN(IF($A$3:$A$13=$G24,IF($B$3:$B$13=$H24,IF($C$3:$C$13=$I24,E$3:E$13))))} J25 {=MIN(IF($A$3:$A$13=$G25,IF($B$3:$B$13=$H25,IF($C$3:$C$13=$I25,D$3:D$13))))} K25 {=MIN(IF($A$3:$A$13=$G25,IF($B$3:$B$13=$H25,IF($C$3:$C$13=$I25,E$3:E$13))))} J26 {=MIN(IF($A$3:$A$13=$G26,IF($B$3:$B$13=$H26,IF($C$3:$C$13=$I26,D$3:D$13))))} K26 {=MIN(IF($A$3:$A$13=$G26,IF($B$3:$B$13=$H26,IF($C$3:$C$13=$I26,E$3:E$13))))} J27 {=MIN(IF($A$3:$A$13=$G27,IF($B$3:$B$13=$H27,IF($C$3:$C$13=$I27,D$3:D$13))))} K27 {=MIN(IF($A$3:$A$13=$G27,IF($B$3:$B$13=$H27,IF($C$3:$C$13=$I27,E$3:E$13))))} <tbody> </tbody>

Formula Array: Produce enclosing { } by entering formula with CTRL+SHIFT+ENTER!

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[gazgazgazgaz]

Thanks folks. Sorted with assistance!

 

[Peter_SSs]

@BillyRaySpivy
When using Excel jeanie, please use the ‘Analyse range (Forum)’ field near the top left to restrict the number of formulas generated. There is generally no need to display multiple formulas that are basically the same, it just fills up the board and makes your post and the thread hard to read/navigate.