Excel 2007 : Identifying Duplicates and adding a value in to a column

Good morning,

Is there a way to look in column A for duplicates and if it finds one, look at a second column and if that column contains a certain text string put a * (or any character) in another column.

So in the example I have attached when in column A it finds a duplicate it then looks to column B and column B contains "Setup" it would return a * in column D.

Thanks in advance!
Dedee

So to help me learn instead of just copying your formula (which works beautifully by the way)...

Count if A2 matches any other value in column A then the if statement says if it's greater >1 (from the counting) return a value of * otherwise return a value of blank.

The only situation it doesn't cover is identifying the column that contains "Setup". As in my example if the data is sorted then the one with "United States" in Column B becomes the one with the * and I'd prefer if the one containing setup in Column B is the one with the *. Or if it's easier could it identify all duplicates but give each set of duplicates a unique character or number return in colum D.

Thank you!

If it contains Setup but does not equal Setup how would that change the formula because the field might be Setup Frank Johns or Setup John Williams etc...

Thanks much!