This is what I have at the moment

=CONCATENATE(ROUND(LARGE(Region!F:F,C4)*100,2),"%" ," -
",INDEX(Region!B:B,MATCH(LARGE(Region!F:F,C4),Regi on!$F:$F,0)))

":)" wrote:

I have a scenario where I need to rank data according to size, top 3 and
bottom 3.
A B C (Large) D
1 20 Car 1 20 - Car
2 15 Dog 2 15 - Dog
3 5 New 3 15 - Are
4 15 Are
5 10 Err

Column A and B are my data, I use column C as reference in the Large and
Small formula and then concatenate with D as the result. But my problem is
when I have 2 similar result as in this example no.2 and 3. What should I do
so that the 3rd highest is correctly reference?