Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Chart with 2 values in each column | Charts and Charting in Excel | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
How sum values in column B using values in column A as the conditi | Excel Worksheet Functions | |||
can i not allow duplicate values in the same column? | New Users to Excel | |||
Removing duplicate values in a column | Excel Worksheet Functions |