Hi All,
I'm a complete excel novice but quickly learning thanks to google. However, one thing I cannot find is the solution for is extracting data by excluding certain numbers.
I have just learnt how to filter data via Advanced filter and was able to get what I want but now I need to do the opposite of what I just did and am needing to exclude about 250 items out of about 87,000.
What I've read on google people are saying it's not possible but tell me it is not true! I really really don't want to have to delete it one by one.
Any help would be greatly appreciated!
I'm a complete excel novice but quickly learning thanks to google. However, one thing I cannot find is the solution for is extracting data by excluding certain numbers.
I have just learnt how to filter data via Advanced filter and was able to get what I want but now I need to do the opposite of what I just did and am needing to exclude about 250 items out of about 87,000.
What I've read on google people are saying it's not possible but tell me it is not true! I really really don't want to have to delete it one by one.
Any help would be greatly appreciated!