I have a spreadsheet that contains 3 columns
Column A is called Deal Number
and contains:
A1:1
A2:2
A3:1
A4:3
A5:1
Column B is called DND
B1:a
B2:a
B3:b
B4:a
B5:c

Column C is called Alert

What i want is to put the word "alert" if column A appears more than once and column B is the last letter of the range.
For example for the above entry, it should only "alert" C5

Hope that makes sense.

Many Thanks for all your help.

Kind Regards,

Rashid