Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 22nd 04, 09:07 PM
Michelle Craig
 
Posts: n/a
Default How do I find out what items are in one list but not in another l.

How do I find out what items in one list are not the same items in another
list. For example, I have a list of people that need to be trained (list A),
and I have a list of people that have recieved the training (List B). I need
an easy way of finding who has not yet been trained from list A.

  #3   Report Post  
Old December 22nd 04, 09:32 PM
Jason Morin
 
Posts: n/a
Default

With list A in col. A and list B in col. C, try this in
B1 and fill down:

=IF(COUNTIF(C:C,A1),"","Not Trained")

HTH
Jason
Atlanta, GA

-----Original Message-----
How do I find out what items in one list are not the

same items in another
list. For example, I have a list of people that need to

be trained (list A),
and I have a list of people that have recieved the

training (List B). I need
an easy way of finding who has not yet been trained from

list A.
.



Reply
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
edit a drop down list paulp Excel Discussion (Misc queries) 1 December 22nd 04 04:20 PM
Selecting data from a list based on entered values GrantM Excel Discussion (Misc queries) 1 December 20th 04 11:59 AM
Linking items GREATER THAN O on another worksheet in the same Work Eddie Shapiro Excel Discussion (Misc queries) 4 December 1st 04 03:55 PM
Find duplicates R. Choate Excel Discussion (Misc queries) 5 November 28th 04 11:14 PM
Counting Repeated text or duplicates in a list Repeatdude Excel Discussion (Misc queries) 5 November 26th 04 08:10 PM


All times are GMT +1. The time now is 02:49 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017