Is that exactly what you want.
. There are some duplicates among the data, like:
john-smith
pattie-walk
john-doe
john-smith
anna-hey
I need to append each duplicate entry with number, so john-smith should look like john-smith-01. If multiple john-smith exists it should keep adding numbers as -02,-03,-04 and so on for each duplicate entry. But also, the unique cells should be copied as they were.
john-smith-01
pattie-walk
john-doe
john-smith-02
anna-hey
Any help with the formula is appreciated.
What you trying to do. Duplicate formula on another row, that is quite simple. You know that just drop down cell. I think you have anything else complex. Kindly share problem with me on chat...