Filter Name

alliswell

Board Regular
Joined
Mar 16, 2020
Messages
57
Office Version
  1. 2007
Platform
  1. Windows
  2. Mobile
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)
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

maabadi

Well-known Member
Joined
Oct 22, 2012
Messages
1,639
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
You can Filter again column Based Customer name with Maintain Previous filtered Subject. No problem.
 
Solution

alliswell

Board Regular
Joined
Mar 16, 2020
Messages
57
Office Version
  1. 2007
Platform
  1. Windows
  2. Mobile
Hi maabadi can you show and send me with example please ? I am new to excel. Not fluent.

Thanks
 

maabadi

Well-known Member
Joined
Oct 22, 2012
Messages
1,639
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
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 NameCustomer NameValue1Value2
1BBB1Alice109171
2BBB2Sam107136
3BBB3Peter191150
4BBB4George178113
5BBB1Mynda138176
6BBB2Jim139116
7BBB3Kathrin195150
8BBB4Michael154191
9BBB1Alice178115
10BBB2Sam100165
11BBB3Peter104140
12BBB4George195104
13BBB1Mynda137104
14BBB2Jim194122
15BBB3Kathrin168116
16BBB4Michael147150
17BBB1Alice171179
18BBB2Sam123171
19BBB3Peter144184
20BBB4George107180
 

Watch MrExcel Video

Forum statistics

Threads
1,127,582
Messages
5,625,620
Members
416,124
Latest member
DeMoNloK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top