topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • Thursday April 18, 2024, 9:36 pm
  • Proudly celebrating 15+ 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

« previous next »
Pages: [1] • bottom

Author Topic: Excel 2007 question  (Read 3782 times)

Josh

  • Charter Honorary Member
  • Joined in 2005
  • ***
  • Points: 45
  • Posts: 3,411
    • View Profile
    • Donate to Member
Excel 2007 question
« on: November 03, 2008, 11:15 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
    • Donate to Member
Re: Excel 2007 question
« Reply #1 on: November 03, 2008, 11:44 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

Target

  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 1,832
    • View Profile
    • Donate to Member
Re: Excel 2007 question
« Reply #2 on: November 03, 2008, 11:56 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
Pages: [1] • top
« previous next »