Fast Filter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Abdul Shakeel - 31 Mar 2008 09:43 GMT

Hi All,

I have a sheet with Column heads

Name Age Class Fees

I have above 2000 rows data is this posible to filter data by tpeing the
data rather I select one. for example in row 1 if I type *Sh & then enter all
data filter

Reply to this Message

Irfan Khan - 31 Mar 2008 10:05 GMT

Apply the auto filter then open the filter and goto Custom... and eneter
whatever condition you want.

Regards

> Hi All,
>
[quoted text clipped - 5 lines]
> data rather I select one. for example in row 1 if I type *Sh & then enter all
> data filter

Reply to this Message

Roger Govier - 31 Mar 2008 12:32 GMT

Hi

I have written some code to allow you to do this.

You can type in *sh* or Sh* or all the usual combinations including the use
of ? as a single placeholder.
Numeric expressions can be AND'd or OR'd
The cells containing any active filters are coloured to show a filter is in
place, and the filter criteria is shown.

A sample file is available for download either from
Debra Dalgleish's site
http://www.contextures.com/Fastfilter.zip

or from Nick Hodge's Excel User Group forum
http://excelusergroup.org/files/folders/allversionwb/entry1194.aspx

Signature

Regards
Roger Govier

> Hi All,
>
[quoted text clipped - 6 lines]
> all
> data filter

Reply to this Message