Menu

Highlighting duplicate values in a column

Search this Thread

Prev

Previous Post

Next Post

Next

#3

Report Post

Jeff

Posts: n/a

Default

(Jeff) wrote in message . com...
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

Ignore this, I've managed to use the validate function

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Column Chart with 2 values in each column	Alec Green	Charts and Charting in Excel	2	February 25th 05 06:12 AM
Formula to compare multiple rows values based on another column?	Murph	Excel Worksheet Functions	4	February 21st 05 02:44 AM
How sum values in column B using values in column A as the conditi	oldgrayelf	Excel Worksheet Functions	5	February 4th 05 09:03 PM
can i not allow duplicate values in the same column?	excel newbie	New Users to Excel	2	January 20th 05 07:51 PM
Removing duplicate values in a column	natan	Excel Worksheet Functions	2	November 22nd 04 06:48 AM

All times are GMT +1. The time now is 12:14 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement