But if he has 50 states that he's going through, then he'll also have to have 50 cells to look at rather than have all the information in either one cell or listed together based on how many actually meet the criteria of the highest.Not familiar with Pivot Tables at all lol.Here is code out on the web that will at least give you only the ones meeting your criteria. Granted, it will not place them in one cell, but just fill the corresponding cells.=IF(ISERROR(INDEX($A$1:$B$50,SMALL(IF($A$1:$A$50=$A$51,ROW($A$1:$A$50)),ROW(1:1)),2)),"",INDEX($A$1:$B$7,SMALL(IF($A$1:$A$50=$A$51,ROW($A$1:$A$50)),ROW(1:1)),2))In order for this to work, here's somethings you will need to do. Place the numbers in column A and the states in column B. In A51, us the formula =MAX($A$1:$A$50) when you place the larger formula in a cell, you MUST hit (CTRL+SHIFT+ENTER) so it will place it as an array, otherwise it will not work. This should get you started at least.
April 2010 Co-MOTM * Custom LED Gauge Cluster swap * LED dome, HVAC, and shifter * Retrofit projector w/ blue halo * Kenwood KDC-HD942U * Herculined cargo area * Debadged *Wolfman's Garage