LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 14
Default Matching values in two columns

Hi,

I have two columns of numbers of about 5,000 rows. EG:
1 8
2 3
6 2
3 5
In this example I just want the numbers 2 and 3 to be left showing in the
left column.

I would like to show only the numbers in the first column that don't have a
corresponding matching number anywhere in the second column. (Or highlighted
in colour.)

Is there a way to do this?

Rob


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Find Matching Data Two Columns Gilly Excel Worksheet Functions 1 December 1st 06 09:11 PM
Data Matching Button for MS Excel 2007 or later Mr. Low Excel Worksheet Functions 0 October 21st 06 10:07 AM
Formula to count values in two columns JBurlage Excel Discussion (Misc queries) 6 August 31st 06 12:59 PM
Req help matching values across columns in Excel Richard B Excel Worksheet Functions 1 May 7th 06 08:31 PM
MATCHING COLUMNS JOE Excel Discussion (Misc queries) 0 May 3rd 06 05:51 PM


All times are GMT +1. The time now is 07:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"