Filter Name

[alliswell]

Hi everybody !
And thanks to every genius who answered my queries kindly without ignoring me. Love u all.

Today i am here with query that i know i am going to get its solution here itself.

In column A1:E1 are field names and are filtered.
Column C has my customers names that are uncountable. C1 is titled as CUSTOMER NAME and is filtered. Usually we scroll down to particular name and select it to get its details. But i want is when i type a customer name in F2, for example : "SAM" it must search in Column C for it and show results like statement of account like if there are 5 transactions of sam it should display 5 results with SAM for example
Sam(C35)
Sam(97)
Sam(C303)
Sam(C4195)
Sam(C5000)

 

[maabadi]

You can Filter again column Based Customer name with Maintain Previous filtered Subject. No problem.

 

[alliswell]

Hi maabadi can you show and send me with example please ? I am new to excel. Not fluent.

Thanks

 

[maabadi]

First you create table (with Press CTRL+T).
At this example you can first filter based company name then you can filter based Customer name (select down arrow and maintain each name you want)

No.	Company Name	Customer Name	Value1	Value2
1	BBB1	Alice	109	171
2	BBB2	Sam	107	136
3	BBB3	Peter	191	150
4	BBB4	George	178	113
5	BBB1	Mynda	138	176
6	BBB2	Jim	139	116
7	BBB3	Kathrin	195	150
8	BBB4	Michael	154	191
9	BBB1	Alice	178	115
10	BBB2	Sam	100	165
11	BBB3	Peter	104	140
12	BBB4	George	195	104
13	BBB1	Mynda	137	104
14	BBB2	Jim	194	122
15	BBB3	Kathrin	168	116
16	BBB4	Michael	147	150
17	BBB1	Alice	171	179
18	BBB2	Sam	123	171
19	BBB3	Peter	144	184
20	BBB4	George	107	180