Print Reseller Scheme
  1. 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?

Discussion in 'Chill Out Forum:' started by Renniks, Mar 30, 2010.

  1. Renniks

    Renniks Senior Member

    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
     
  2. berry

    berry Active Member

    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
     
  3. Renniks

    Renniks Senior Member

    Sadly Berry need the information sooner than the post can travel :D Much appreciated offer though.
     
  4. glenwheeler

    glenwheeler Senior Member

    I did a lot of excel work in the past, I dont understand your question thought lol?
     
  5. Renniks

    Renniks Senior Member

    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)
     
  6. tbwcf

    tbwcf Active Member

  7. Renniks

    Renniks Senior Member

    :) 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)
     
  8. Renniks

    Renniks Senior Member

    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 :)
     
  9. Renniks

    Renniks Senior Member

    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
     
  10. tbwcf

    tbwcf Active Member

    Good news!
     
  11. Renniks

    Renniks Senior Member

    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
     
  12. Renniks

    Renniks Senior Member

    Solved this problem now, just had to change something in the macro so it delimited properly, sigh
     

Share This Page