How Auto filter

[Baldev Kumar]

Dear Experts,


Is it possible that table filter work on value entered in A1 Cell, in example sheet if i enter the value "kam" in cell A1, table column "Name" filter "kam" from the table.

auto filter.xlsx

[Pete_UK]

I've moved things over, so as not to affect your table, so you can enter your name in F1 and see the filtered results below. You can hide columns D and E if you want to.

Hope this helps.

Pete

[Baldev Kumar]

this is very helpful. but actually i have a large table (approx 26k rows with 38 unique location names)and i am adding rows on daily basis. so i want to avoid extra column. isn't it possible to work with the existing table?

[martindwilson]

type the word "name" in say d1 in d2 type kam
advanced filter
filter in place
list range $A$2:$A$1000
criteria range $D$1:$D$2

[Baldev Kumar]

Thank you, this is very helpful