Rather than pop up a message, how about if you set the conditional
formatting for the cells in column B to highlight if a duplicate
extension is entered?
Set conditional formatting to "formula is" and use this formula
(altered, of course, to fit your data):
=COUNTIF($B$2:$B$17,B2)1
Then set it to highlight in red or yellow to indicate a duplicate.
|