Hello all,
I am a first time poster, and would really appreciate your help.

I am relatively new to using VBA and I have a question regarding a problem I encountered at work regarding a macro I am trying to create that would help me out at work and save me days of work down the road.
I have a large subset of data that I would like to assign values to cells in column C based on criteria in the Column D.

Column D contains company names, and I would like Column C to display the value Ts, Id, BI based on the following criteria.

Ts = company name appearing less than or equal to 250 times in the data, and “Mr” or “Mrs” does not appear in the company name.

ID – appears less than or equal to 2 times in the data, and includes “Mr” or “Mrs”.

Bi – Company name appears more than 250 times.

I know I have to work with if statements, but the fact that I am also looking for duplicates is really throwing me off. Your help is greatly appreciated.

Thank you for your help,

Nic