LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BP BP is offline
external usenet poster
 
Posts: 2
Default Need help comparing 2 columns of number to find unique numbers

I have 2 columns of numbers. The first column is a list of unique IDs
(221 IDs) that have signed up for a training program. The second
column is the full list of people who are assigned to course (360
IDs). I need a third column to display only the IDs that do not show
up in the first column.

Any help would be appreciated.
 
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
comparing columns to find dup's stacey Excel Worksheet Functions 2 April 24th 09 01:24 AM
comparing columns to find a difference ysobored Excel Worksheet Functions 1 October 17th 08 08:03 PM
Find total number of unique model numbers Brian Excel Worksheet Functions 8 September 19th 08 05:51 AM
find a number between numbers in two separate columns confused about ranges Excel Worksheet Functions 2 December 30th 06 01:41 PM
two columns of numbers, need to sort/filter to find one number th. Larry in Seattle Excel Discussion (Misc queries) 1 December 10th 04 06:17 AM


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

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

About Us

"It's about Microsoft Excel"