Filtering by entering a an item in a Cell

**Statue** · 04-14-2013, 10:29 PM

Hi,
I want to filter this document like when I type "10A" in "B3" it must be filtered to all 10A students.
If you could help me it would be a great success.
Thank you in advance.Check.xlsx

**Tony Valko** · 04-14-2013, 10:38 PM

Have you tried using autofilter?

Select your data including the column headers.

Goto the Data tab>Filter

Click the drop arrow on the Class column and select the filter options of your choice.

**Statue** · 04-14-2013, 10:52 PM

Thank you for your reply,
Yes I have tried that but i just wanted to know if there is any other method for filtering.

**RS15** · 04-14-2013, 10:57 PM

it must be filtered to all 10A students

What do you mean by it must be filtered?

**Tony Valko** · 04-15-2013, 09:00 AM

You can use formulas to extract the data you want to a new location.

This method may not be very practical if you have 1000's of rows and many columns of data.

Still interested?