Trying to assign a value to cells based off of predetermined criteria

Hello sclog,

Welcome to the forum!
In cell C2 and copied down, give this formula a try:

=IF(COUNTIF(D:D,D2)>250,"Bi",IF(ISNUMBER(SEARCH("Mr",D2)),"ID","Ts"))

Thank you for replying tigeravatar. This formula worked for Ts, and Bi, which was a huge help. But it doesn't seem to work for the cells labeled Id.

I was thinking about using the Instr function in my macro to help with that. Do you think that could solve my issue? Or should I just add more to the formula you provided?

EDIt: Nevermind I am clearly wasn't paying attention it works fine. Thank you TigerAvatar.