|I do not belive that you can use a formula to accomplish your goal. A formula cannot "loop" through a column and build a variable length string depending on whether it finds one Top Ranked value or two or possibly even five. |
Perhaps there may be an extremely complicated Nested IF/Nested VLOOKUP formula that accounts for every possible scenario, but I wouldn't even attempt to construct it.
One formula based option would be to use a technique that allows you to "break" ties by using a "Helper Column" to add a very small random number to each value, basically eliminating the possibility that there will ever be 2 values that are tied for first. If you are interested in that solution, let me know.
Otherwise, the other option would be a macro which could easily build the random length string for any number of Top Ranked ties. I think we could come up with a User Defined Function (UDF) that could be used in a cell, but that would still be a macro based solution.
Let me know if you are interested in a macro based solution.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.