Figuring out which numbers don't exist in list

**dip11** · 07-31-2012, 11:54 AM

Hi,

In the attached worksheet, how do I figure out which numbers have not been matched yet based on the min and max values?

Thanks

**Fotis1991** · 07-31-2012, 12:21 PM

Hi

For me, your request is not clear. Can you explain a little more, pls?

**baldphil** · 07-31-2012, 01:23 PM

I've attached a file with a formula that returns true if a given number is in the list, false otherwise. Not sure if this is what you are looking for, though. The formula is "=IFERROR(MATCH(G1, $A$2:$A$22, 0), -1)>0", where $A$2:$A$22 is the list, and G1 holds the value to be checked.

NotInList.xlsx

**dip11** · 08-01-2012, 07:32 AM

I have a column, let's call it X which has 1 number per row from 1 to 12576.

I also have a column Y which has the numbers as per the attached spreadsheet, which are within the range of 1-12576 but miss about 500 numbers.

What I want is for Excel to delete all rows in which the number matches, so it leaves only the rows which have unmatched numbers.

-

Figured out how to do it myself...VLOOKUP, sort, delete.