Hi,

I have a list with approx. 20,000 entries. Most of the entries in the list appear 4 times which is what I want. However, there are also about 100 entries, that appear 8, 12 or 20 times. I want to change the names of these additional repeats:
Repeat 1-4 of a specific entry should not be changed. Entry 5-8 should recieve an "A" at the end of their description in column A. If present, entry 9-12 should recieve a "B",...

It is important that the order of the list is not changed.

Is that possible with Excel?

Thanks