Posted to microsoft.public.excel.programming

kyle.macdonald[_2_] kyle.macdonald[_2_] is offline

external usenet poster

Posts: 1

FINDING DUPLICATES - CROSS REEFERENCE 2 COLOUMNS TO FIND UNIQUE EN

I HAVE A LIST CONSISTING OF 2 COLUMNS. I MUST FIND THE DUPLICATE IN ONE LIST
AND HIGHLIGHT THEM.

EXAMPLE:

LIST 1.

COLUMN 1 COLUMN 2

A12A 12384
A129D 1987
A139D 1987
A12A 12843

THESE WOULD BE UNIQUE!

A12A 12345
A12A 12345

tHIS WOULD BE A DUPLICATE.

WOULD BE APPRECIATIVE OF YOUR HELP!

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
Finding all unique rows and excluding all duplicates	waylonk	Excel Discussion (Misc queries)	0	May 3rd 10 08:43 PM
Finding Unique/Duplicates	IMS Lori	Excel Worksheet Functions	5	October 21st 09 09:24 AM
Help finding a fast way to cross reference data between sheets???	Scott	Excel Discussion (Misc queries)	1	August 18th 08 04:51 PM
How to intersect two coloumns in a third coloumns	jessie	Excel Programming	3	December 19th 06 11:41 PM
Finding the value for the point two lines cross	Brian	Charts and Charting in Excel	1	March 2nd 06 11:59 PM

All times are GMT +1. The time now is 06:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us