• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Any Excel "wizards" on here?


Renniks

Senior Member
#1
Need help with an excel problem that I am struggling to solve, even with the use of google :(

Essentially I have a file I want to filter, but excel 2003's autofilter only gives a maximum of 2 conditions for filtering

I want to filter 100 conditions on the same column

Example with 3 conditions


Day ........................ Food
Monday .......................Bread
Tuesday .....................Chicken
Monday ........................Anything
Wednesday.................ARgh
Thursday.....................Stuck
Friday ..........................Dont
Saturday.......................Know

Then filter when column "day" ... DOES NOT CONTAIN : Monday, Tuesday, Wednesday


Thanks if you can help or know of an article for helping (essentially my difficulty is the filter criteria setting up, especially for 'does not contain')

:) Renniks
 

berry

Active Member
#2
I have an great Excel paperback book that is Janet and John to use. Excel made Easy £2.99 ( Big print!)
If you want I can post it down
 

Renniks

Senior Member
#5
Lol, ermm Hard to explain it any differently.
Autofilter has a max of 2 options
I want more...
:)
(Its not really viable to search through 10,000 entries and delete those I've accounted for, especially as the process will be repeated)
 

Renniks

Senior Member
#7
:) Thanks, lets hope
a) I can use it (haven't looked, thanking in advance either way)
b) I can install it (stupid non admin privileges on computers)
 

Renniks

Senior Member
#8
Ace just read it and it would seem I dont need privileges to run it, :) will test tomorrow as I don't have office (got open office) on this 'puter :)
 

Renniks

Senior Member
#9
Huge thanks to Andy,
The "program" he suggested does the job perfectly, with lots of different features.
Definitely a big thumbs up from me :D
 

Renniks

Senior Member
#11
Another question, which I've botched but in case the process is repeated:

Anyone know how (or have a macro that allows) to import over 65636 rows... With delimiters...
Found one that allows without... but not with :)

Thanks