View Single Post
  #1   Report Post  
Jeff
 
Posts: n/a
Default Highlighting duplicate values in a column

Our department is involved in project managing office moves. The
moving department is given an excel 2002 spreadsheet and they fill out
the names of the people moving (column A) along with their extension
number (column B). I would like it to pop up a message if an
extension number is entered and is a duplicate of one already entered,
giving the person's name it's duplicated with.

Any help would be gratefully received

TIA