Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract "Does not equal" data
Good morning
Have searched this and cant quite figure it out. I have a column containing 1122 numbers. They are unique numbers. I have another column that contains 359 of those 1122 numbers. How can I determine which are the remaining 763 numbers. In other words, not equal to the 359 numbers. Auto filter wont work; I cant copy in the 359 numbers after using the Does Not Equal filter in the Custom box from the Drop-down Autofilter menu. I am stumped! Thanks to anyone who takes the time to answer. Ill keep a close eye on this post for responses. sam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Having a pie chart ignore data fields equal to "0" | Excel Discussion (Misc queries) | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
sort data rows "greater than or equal" criteria in another cell | Excel Worksheet Functions |