Trying to remove duplicate names from a look up code to count

This is confusing so I attached a spreadsheet. Basically, I have location codes and I need each person listed once for each location code and I can't list the Vacancies. I end up using these people for a different file and I also need to use it to count how many people are at each location code. I know the simple ways of doing this if I only needed one thing. However, I need to use it for so many different files that I'd like to pull the detail back in this manner. Please see attached file and tell me if this is possible?

Thanks so much in advance!!

Try this in G5:

=IF(OR(C5="VACANCY",COUNTIFS(B$5:B5,B5,C$5:C5,C5)<>1),"",C5)

AMAZING!!! This worked!!! Thank you both so so so much!!!

You're welcome. Glad we could help.