L
Legacy 461286
Guest
I have a table containing 5 rows the headers for each are in column A. Each row contains values that are summed up and this is displayed in the total column (Column H).
I want to show in a separate table below the order/rank of these from 1 to 5. I have managed to do this so far by
=INDEX($A$2:$A$6,MATCH(ROWS($H$2:H2),$I$2:$I$6,0))
This works fine if the totals for each row are different. If I have any duplicates i then encounter an issue as one of the row names is not displayed.
Ideally I would be able to show any duplicates in the same cell e.g.
1st - Row1
2nd - Row2
3rd - Row3, Row4
4th - Row5
5th -
can anyone help me out?
I want to show in a separate table below the order/rank of these from 1 to 5. I have managed to do this so far by
=INDEX($A$2:$A$6,MATCH(ROWS($H$2:H2),$I$2:$I$6,0))
This works fine if the totals for each row are different. If I have any duplicates i then encounter an issue as one of the row names is not displayed.
Ideally I would be able to show any duplicates in the same cell e.g.
1st - Row1
2nd - Row2
3rd - Row3, Row4
4th - Row5
5th -
can anyone help me out?