Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • December 03, 2016, 08:00:04 PM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Excel 2007 question  (Read 1974 times)

Josh

  • Charter Honorary Member
  • Joined in 2005
  • ***
  • Points: -5
  • Posts: 3,395
    • View Profile
    • Donate to Member
Excel 2007 question
« on: November 03, 2008, 11:15:09 PM »
To all,

I am looking for a way to have a text field in excel 2007 where I can type in a value and have excel filter out all rows that do not contain that text.

Does anyone know of a way to do this in excel 07?

Josh

Darwin

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,984
    • View Profile
    • Read more about this member.
    • Donate to Member
Re: Excel 2007 question
« Reply #1 on: November 03, 2008, 11:44:40 PM »
ASAP Utilities is a fantastic, free Excel add-in that should allow you to do this, although I suspect you already have it installed and that I've misunderstood what you're after  :o
"Some people have a way with words, other people,... oh... have not way" - Steve Martin

Target

  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 1,605
    • View Profile
    • Donate to Member
Re: Excel 2007 question
« Reply #2 on: November 03, 2008, 11:56:29 PM »
advanced filters are supposed to be able to do this, though having said that I've never been able to get it to work...

You could write an on change routine to amend the existing filter criteria though