caballeroblanco
New Member
- Joined
- Feb 13, 2009
- Messages
- 6
Is there any way that I can construct a pivot table to show the nth largest value for each row label.
If your data is in the range A1:C43, in D1 enter a header, eg LargeR1. In D2 type:
=LARGE(IF($A$2:$A$43=$A2,B$2:B$43),3)
and press Ctrl+Shift+Enter not just Enter. If correctly entered Excel will surround this array formula with curly braces {}. Copy the formula to D3:D43.
Now create a pivot table with Race as the row field and Average of LargeR1 as the data field.