Ties in ranking

I know that most people like to eliminate ties in a ranking. I would actually like to keep the ties, but would like to have a column that notates that a tie exists.

SO...

I will have a column of results...simple numbers. In some cases there will be as many as 100 numbers that are ranked. In the next column, a ranking of those numbers will occur. What I need help with is the next column. I would like to have "TIE" appear if any of the rankings (1,2,3,4...) match any other ranking in the list.

Therefore, if there are 3 rankings of "7", I would like "TIE" to be placed in each column so that we can go back and address each individually.

What would be the best formula to make this happen? If there is a choice, please aim for a slightly older version of excel as we are having to use an older computer.

Thanks in advance for any help!

I would sort the rankings smallest to largest. In the second column put the formula =IF(A2=A3,"TIE"," "). You may need to adjust your cell references that are checking for the tie.

Unfortunately, we will be entering and eliminating ties in real time, therefore any kind of sorting by rank will not work very well. Your solution is good, but in this case we need to see the ties quickly and automatically.

Any other ideas?

How about using conditional formatting for duplicate values?