Basic leaderboard

I have created the attached dashboard and am trying to create a leaderboard to show in columns CDE in the bottom left of the worksheet. The leaderboard is using data from a second sheet where this has number of categories/tag used. I have managed to pull some of the data across but it is not ordering correctly.

I have used the following formulas:

column D
=INDEX('Category Summary'!A$2:A$31,MATCH(LARGE('Category Summary'!$P$2:$P$31,C45),'Category Summary'!$P$2:$P$31,0))

column E
=INDEX('Category Summary'!O2:O31,MATCH(LARGE('Category Summary'!$P$2:$P$31,Dashboard!C45),'Category Summary'!$P$2:$P$31,0))

Any help would be much appreciated.

Thanks for the reply avk,

Sorry I may not have explained my self very well. i wanted the top 10 categories/tags for example to be listed. The resolution you have mentioned only seem to list what is shown in the graph. Unless I have missed something.

Thanks in advance.

Have a look at the attached and see if that is what you are after.

I ranked them first in the category summary tab, then did a index/match which can handle duplicates.

All arrays:

=SMALL(('Category Summary'!$N$2:$N$31),ROWS($1:1))
=IF(LEN(Dashboard!C46),INDEX('Category Summary'!$O$2:$O$32,SMALL(IF('Category Summary'!$N$2:$N$32=Dashboard!C46,ROW('Category Summary'!$1:$31)),COUNTIF(C$46:C46,C46))),"")
=IF(LEN(Dashboard!C46),INDEX('Category Summary'!$P$2:$P$32,SMALL(IF('Category Summary'!$N$2:$N$32=Dashboard!C46,ROW('Category Summary'!$1:$31)),COUNTIF(C$46:C46,C46))),"")

Hi Milixcel,

That seemed to work very well for the Rank column C45 onwards, but the name and total of the tag has not been returned. It only shows as #Value!. I did have to add one new tag so amended the range sligtly (in bold below)to what I though should work but this did not help either.

=IF(LEN(Dashboard!C46),INDEX('Category Summary'!$O$2:$O$32,SMALL(IF('Category Summary'!$N$2:$N$32=Dashboard!C46,ROW('Category Summary'!$1:$32)),COUNTIF(C$46:C46,C46))),"")
=IF(LEN(Dashboard!C46),INDEX('Category Summary'!$P$2:$P$32,SMALL(IF('Category Summary'!$N$2:$N$32=Dashboard!C46,ROW('Category Summary'!$1:$32)),COUNTIF(C$46:C46,C46))),"")

I have attached the updated workbook if you could help any more it would be much appreciated.

Change the last $32 to $31 and it should work, input as array (Ctrl + Shift + Enter together)

=IF(LEN(Dashboard!C46),INDEX('Category Summary'!$O$2:$O$32,SMALL(IF('Category Summary'!$N$2:$N$32=Dashboard!C46,ROW('Category Summary'!$1:$31)),COUNTIF(C$46:C46,C46))),"")
=IF(LEN(Dashboard!C46),INDEX('Category Summary'!$P$2:$P$32,SMALL(IF('Category Summary'!$N$2:$N$32=Dashboard!C46,ROW('Category Summary'!$1:$31)),COUNTIF(C$46:C46,C46))),"")

Brilliant thank you so very much.