Searching Column Multiple Times & Adding +1 To Text

Hello!

I'm in need of some help. I'm trying to create unique ID for a list of contacts and it involves searching the same column multiple times. Here's the outline.

In column B:
It has a list of companies. It could list multiple companies or individuals companies. Like this:

ABC
ABC
ABC
AMCE
JET
JET
APPLE

In column C:
I would like to provide the output that basically creates a unique ID. I want to to search the existing list (Column B) and add a +1 every time the same company is found. For example this is the output I would like for column C:

ABC-0001
ABC-0002
ABC-0003
ACME-0001
JET-0001
JET-0002
APPLE-0001

As you can see for ABC, the first column it's the first ABC in the list so it adds a 1. Then it finds a second ABC so it adds another 1 and so on. If the company is only shown once it would just have 1.

Thank you so much for your help

Try this:

=B1&"-"&TEXT(COUNTIF(B$1:B1,B1),"0000")

You're welcome!

In future, please do not open multiple threads on the same issue, which is against the forum rules: just wait patiently for help. Thanks.