using Large function to sort a column of numbers

[grantjw]

I have 3 columns of data: col. A = name (random order), col. B = Net #, Col. C = Gross #.

I am using =LARGE(C$1:C$4466,ROWS($D$1:D1) to Automatically sort col C in decending order.

I would Like to do another decending sort but only the values in Col C that corespond to a particular name in Col A. Can I imbed a index match function combination within the large function to do this?

[TABLE="width: 500"]
<TBODY>[TR]
[TD][TABLE="width: 550"]
<COLGROUP><COL style="WIDTH: 109pt; mso-width-source: userset; mso-width-alt: 5302" width=145><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 105pt; mso-width-source: userset; mso-width-alt: 5120" width=140><COL style="WIDTH: 48pt" span=5 width=64><TBODY>[TR]
[TD="width: 145, bgcolor: transparent"]Name[/TD]
[TD="width: 64, bgcolor: transparent"]Net[/TD]
[TD="width: 64, bgcolor: transparent"]Gross[/TD]
[TD="width: 140, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"]All Sort[/TD]
[TD="width: 64, bgcolor: transparent"]SortA[/TD]
[TD="width: 64, bgcolor: transparent"]SortB[/TD]
[TD="width: 64, bgcolor: transparent"]SortC[/TD]
[TD="width: 64, bgcolor: transparent"]SortD[/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]A[/TD]
[TD="bgcolor: transparent, align: right"]508[/TD]
[TD="bgcolor: transparent, align: right"]-200.129[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]101.685[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]C[/TD]
[TD="bgcolor: transparent, align: right"]107[/TD]
[TD="bgcolor: transparent, align: right"]-34.5861[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]73.982[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]D[/TD]
[TD="bgcolor: transparent, align: right"]241[/TD]
[TD="bgcolor: transparent, align: right"]-64.784[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]65.606[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]A[/TD]
[TD="bgcolor: transparent, align: right"]449[/TD]
[TD="bgcolor: transparent, align: right"]-171.537[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]51.4022[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]B[/TD]
[TD="bgcolor: transparent, align: right"]445[/TD]
[TD="bgcolor: transparent, align: right"]65.606[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-13.6608[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]A[/TD]
[TD="bgcolor: transparent, align: right"]411[/TD]
[TD="bgcolor: transparent, align: right"]-157.414[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-15.9449[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]D[/TD]
[TD="bgcolor: transparent, align: right"]251[/TD]
[TD="bgcolor: transparent, align: right"]-44.4871[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-16.5229[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]B[/TD]
[TD="bgcolor: transparent, align: right"]359[/TD]
[TD="bgcolor: transparent, align: right"]-22.8478[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-19.5838[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]C[/TD]
[TD="bgcolor: transparent, align: right"]96[/TD]
[TD="bgcolor: transparent, align: right"]-27.9752[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-22.8478[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]A[/TD]
[TD="bgcolor: transparent, align: right"]397[/TD]
[TD="bgcolor: transparent, align: right"]101.685[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-23.3072[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]A[/TD]
[TD="bgcolor: transparent, align: right"]402[/TD]
[TD="bgcolor: transparent, align: right"]-152.452[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-23.8842[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]C[/TD]
[TD="bgcolor: transparent, align: right"]89[/TD]
[TD="bgcolor: transparent, align: right"]-23.3072[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-27.9752[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]A[/TD]
[TD="bgcolor: transparent, align: right"]422[/TD]
[TD="bgcolor: transparent, align: right"]-141.114[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-33.4352[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]B[/TD]
[TD="bgcolor: transparent, align: right"]444[/TD]
[TD="bgcolor: transparent, align: right"]51.4022[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-34.5861[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]D[/TD]
[TD="bgcolor: transparent, align: right"]233[/TD]
[TD="bgcolor: transparent, align: right"]-33.4352[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-42.8249[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]A[/TD]
[TD="bgcolor: transparent, align: right"]450[/TD]
[TD="bgcolor: transparent, align: right"]-91.0501[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-44.4871[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]C[/TD]
[TD="bgcolor: transparent, align: right"]84[/TD]
[TD="bgcolor: transparent, align: right"]-16.5229[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-64.784[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]A[/TD]
[TD="bgcolor: transparent, align: right"]510[/TD]
[TD="bgcolor: transparent, align: right"]73.982[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-91.0501[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]C[/TD]
[TD="bgcolor: transparent, align: right"]85[/TD]
[TD="bgcolor: transparent, align: right"]-19.5838[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-141.114[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]B[/TD]
[TD="bgcolor: transparent, align: right"]454[/TD]
[TD="bgcolor: transparent, align: right"]-13.6608[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-152.452[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]B[/TD]
[TD="bgcolor: transparent, align: right"]408[/TD]
[TD="bgcolor: transparent, align: right"]-23.8842[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-157.414[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]C[/TD]
[TD="bgcolor: transparent, align: right"]86[/TD]
[TD="bgcolor: transparent, align: right"]-15.9449[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-171.537[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl24, bgcolor: transparent"]D[/TD]
[TD="bgcolor: transparent, align: right"]229[/TD]
[TD="bgcolor: transparent, align: right"]-42.8249[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-200.129[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[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]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[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]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[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]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

 

[pplstuff]

After pasting in your data to A1, and changing "SortX" to "X"

F2:
=IF(ROWS($F$1:F1)>COUNTIF($A$2:$A$24,F$1),"",INDEX($C$1:$C$24,LARGE(IF($A$1:$A$24=F$1,ROW($C$1:$C$24)),ROWS($F$1:F1))))
Confirm with control + shift + enter

 

[shg]

Why not just sort by Name and then by Gross?

 

[grantjw]

Thanks for the quick reply. I did what you recommended. I got results close to what I expected. for sort on "A" I expected : 101.685, 73.982, -91.0501 .... Did I do something wrong?


[TABLE="width: 468"]
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" span=4 width=73><TBODY>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 69, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 69, bgcolor: transparent"][/TD]
[TD="width: 73, bgcolor: transparent"]A[/TD]
[TD="width: 73, bgcolor: transparent"]B[/TD]
[TD="width: 73, bgcolor: transparent"]C[/TD]
[TD="width: 73, bgcolor: transparent"]D[/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]508[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-200.129[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]101.685[/TD]
[TD="class: xl27, bgcolor: transparent"]73.982[/TD]
[TD="class: xl27, bgcolor: transparent"]-23.8842[/TD]
[TD="class: xl27, bgcolor: transparent"]-15.9449[/TD]
[TD="class: xl27, bgcolor: transparent"]-42.8249[/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]C[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]107[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-34.5861[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]73.982[/TD]
[TD="class: xl27, bgcolor: transparent"]-91.0501[/TD]
[TD="class: xl27, bgcolor: transparent"]-13.6608[/TD]
[TD="class: xl27, bgcolor: transparent"]-19.5838[/TD]
[TD="class: xl27, bgcolor: transparent"]-33.4352[/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]D[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]241[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-64.784[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]65.606[/TD]
[TD="class: xl27, bgcolor: transparent"]-141.114[/TD]
[TD="class: xl27, bgcolor: transparent"]51.4022[/TD]
[TD="class: xl27, bgcolor: transparent"]-16.5229[/TD]
[TD="class: xl27, bgcolor: transparent"]-44.4871[/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]449[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-171.537[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]51.4022[/TD]
[TD="class: xl27, bgcolor: transparent"]-152.452[/TD]
[TD="class: xl27, bgcolor: transparent"]-22.8478[/TD]
[TD="class: xl27, bgcolor: transparent"]-23.3072[/TD]
[TD="class: xl27, bgcolor: transparent"]-64.784[/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]B[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]445[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]65.606[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-13.6608[/TD]
[TD="class: xl27, bgcolor: transparent"]101.685[/TD]
[TD="class: xl27, bgcolor: transparent"]65.606[/TD]
[TD="class: xl27, bgcolor: transparent"]-27.9752[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]411[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-157.414[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-15.9449[/TD]
[TD="class: xl27, bgcolor: transparent"]-157.414[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"]-34.5861[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]D[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]251[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-44.4871[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-16.5229[/TD]
[TD="class: xl27, bgcolor: transparent"]-171.537[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]B[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]359[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-22.8478[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-19.5838[/TD]
[TD="class: xl27, bgcolor: transparent"]-200.129[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]C[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]96[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-27.9752[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-22.8478[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]397[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]101.685[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-23.3072[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]402[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-152.452[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-23.8842[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]C[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]89[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-23.3072[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-27.9752[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]422[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-141.114[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-33.4352[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]B[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]444[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]51.4022[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-34.5861[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]D[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]233[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-33.4352[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-42.8249[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]450[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-91.0501[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-44.4871[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]C[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]84[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-16.5229[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-64.784[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]A[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]510[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]73.982[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-91.0501[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]C[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]85[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-19.5838[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-141.114[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]B[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]454[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-13.6608[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-152.452[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]B[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]408[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-23.8842[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-157.414[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]C[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]86[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-15.9449[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-171.537[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl24, width: 64, bgcolor: transparent"]D[/TD]
[TD="class: xl25, width: 64, bgcolor: transparent"]229[/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-42.8249[/TD]
[TD="class: xl26, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl25, width: 69, bgcolor: transparent"]-200.129[/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[TD="class: xl27, bgcolor: transparent"] [/TD]
[/TR]
</TBODY>[/TABLE]

 

[pplstuff]

Apologies, I was in a hurry when I wrote that.

This should do the trick, one caveat, this will not handle duplicate (ex. if there are two A 100s)

=IF(ROWS($F$1:F1)>COUNTIF($A$2:$A$24,F$1),"",INDEX($C$2:$C$24,MATCH(LARGE(IF($A$2:$A$24=F$1,$C$2:$C$24),ROWS($F$1:F1)),$C$2:$C$24,0)))
confirm with control + shift + enter

 

[grantjw]

SHG, Was looking for a function to do this automatically. My data will be changinig each month did not want user to do sorting or changing the spreadsheet.

 

[grantjw]

That did it. Thanks!