| 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) | |||
Threaded Mode
