Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to find "missing" data
Hi!
I am looking for a formula that can: I have a list of (nearly) identical numbers in two columns. In one column there are 100 numbers and in column 2 there are 90 numbers. Is there a formula or macro which can find the 10 numbers which are in column 1, but not in column 2 and list them in at third column? I am testing two databases that should have the same data, but doesn't. I have the 2007 version of Excel. LEG |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Signature missing when "send to" "mail recipient" | Excel Discussion (Misc queries) | |||
Missing data and "invalid references" | Charts and Charting in Excel | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) |