# extract non duplicate cells

1. ## extract non duplicate cells

HI Guys

here is the thing i hae 2 list have ALMOST have the same records i want a formula that extract the non duplicate cells

here's an example:-

LIST 1:

@ # \$ % ^ & *

LIST 2:
@ # \$ %

i want to end up with this:-

^ & *

i hope you get th point guys cuz my list contains at least 2000 record

please can you tell me which formula i should use and please dont tell me the VLOOKUP & FILTER cuz they dont work

2. Based on your example, your two lists are in 2 rows and not in 2 columns? If that's the case, in the next row, (assume your lists are in rows 1 and 2),
``Please Login or Register  to view this content.``
and drag that to the right.

Then go to Data Sort and set it to accending and set the options to left to right. That will put all your false values (or non-matches) first. The second row from A to wherever the Falses end will be your unique values in Row 2. Repeat with Row 1.

Is that what you are looking for?

ChemistB

3. Thankx man....but mine in 2 columns not rows.....can i use the same function?

4. also i dont want him to show me the word "TRUE" or "FALSE"

ok here is the really thing that am working on

i have 2 sheets

sheet 1: have a tables these tables are a student semester in each semester it written the courses he took and besides these tables there is a small table for the extra courses he took which is not in one of these semester tables

sheet 2:i have a table contains 3 columns

the first is the student ID

the sec is the name of the course he took

the thr is the grade for the course

ok what i want is

the "extra courses table" in sheet 1....i want to compare between the courses he took in the semester and in the list(sheet2) and past the non duplicate courses in the "extra courses table"

i hope i was clear i'll post the file to have a look at

5. Might there be duplicates in the same column?
Otherwise there is a solution at http://www.cpearson.com/excel/ListFunctions.aspx
under Extracting Elements From One List Not On Another List

6. WoW thankx man it's working now but there is 1 tiny thing

ok after i put the extra courses when i change the student ID and put another student ID the extra courses for the new ID should appear

but it's not?????

even though i put the \$ between the cell name (absolute references)

is there a way to make a connection beween the 2 cell so when i put a new ID it should change in the extra courses cell

7. ## ...

This might help (see attachment).
I had to shorten the input range to meet the attachment limitations.
Sheet3 is just a test but might be useful.
//Ola

Link: If you are unfamiliar to Array formulas read the first text with a blue background.

8. WOOOOOOOOOOOOOOOW

thankx man but MAN you've changed the hole workbook

when i opened it i didnt understand anything!!!!!!....will still i am

but thankx man for your help

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1