Return two or more high scores of the same value.....

You would need a UDF (macro) to do this..

Insert this macro into your VB Editor (Alt+F11, Insert|Module):

Please Login or Register  to view this content.

Then in B23 enter formula:

Please Login or Register  to view this content.

confirm it with CTRL+SHIFT+ENTER, not just ENTER and copy across.

Then select the row 23 results and format the cells, and set Alignment to Wrap Text, and expand the rows to see all results.

The macro was not actually written by me. It is written by a well know Excel Guru, Harlan Grove. It actually is a User Defined Function... so it the formula you use that invokes the UDF to work (because it is like a built in function, except it is customized by a user).

So working from the inside out, as Excel evaluates formulas...

aconcat(IF(B3:B22=MAX(B3:B22),$A3:$A22,"")," ")

aconcat() is the User Defined Function and at its most basic the function was designed to overcome Excel current CONCATENATE() function, which unfortunately is lacking, as it does not allow you to use ranges, and instead you have to specifically enter each cell to concatenate in the function.

So say you want to concatenate all the cells from A1:A10. With Excel's native function, CONCATENATE() you would need to write it as

=CONCATENATE(A1,A2,A3,A4,A5,A6,A7,A8,A9,A10) which isn't so bad, but if the range was A1:A100, then have fun...

with this UDF, you can simply write: =aconcat(A1:A10) and voila, same result. It also has the added optional benefit of allowing you to automatically include a separator... so, =aconcat(A1:A10,",") would concatenate the 10 cells, and separate each result with a comma... with CONCATENATE() you would need too physically include that between each cell reference... e.g. =CONCATENATE(A1,",",A2,",",A3,",",....) as you see, I already gave up in going through and adding all 10 cells...

Another feature of this aconcat() UDF is the ability to include conditional concatenating... so we want to concatenate the cells in A3:A22 only if B3:B22 matches the MAX value in B3:B22 and if there isn't a match, a null ("") is returned. If we had put a comma as the optional separator here, we would get a commas even where the nulls occur... so you could get a result like: ,,2,3,,,,4,,,,5 which wouldn't look very nice, so instead, we will use a space as a separator, so it the result will look more like: 2 3 4 5. This still isn't nice looking, but adding the TRIM() function removes all the extraneous spaces... so the result will then be 2 3 4 5. Now it looks better.. and some people might actually want that... but you can now use the SUBSTITUTE() function which will allow you to substitute any character with any other character throughout the string.. so we can replace the spaces with commas to get: 2,3,4,5. That might be what you really wanted, and you can revert to that easily enough. I, however, assumed that you might want to separate each with a carriage return so that they line up below each other. The CHAR(10) is results in a character return symbol, which WRAP aligning converts to actual wrapped text string.

The CTRL+SHIFT+ENTER tells Excel that this is an array formula (it's a feature of Excel, not the UDF), because we are processing an array of cells, not just one at a time... that produces the { } around the formula. Here is more on Array Formulas... http://www.cpearson.com/excel/ArrayFormulas.aspx

hope that helps