Advanced Filter Criteria ?ion

Pinaceous

Well-known Member
Joined
Jun 11, 2014
Messages
784
Office Version
  1. 365
Platform
  1. Windows
Hi All,

I am working with Excel 2013 & I want to 'Advance Filter' with more than one Criteria in a Cell w/o 'Advanced Filtering' for a 2nd time based on another criteria in further reducing the produced list.

ie.

Criteria:

NameNumber
<>Charles

<tbody>
</tbody>

Now, if I want to also omit another name w/o Advance Filtering for a 2nd time, for example, to further omit <>Michael; How can I do this in its original cell?


Is there a way to join in that original criteria cell, <>Charles & <> Michael?

Many Thanks,

-Pin
:confused:
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Momentman

Well-known Member
Joined
Jan 11, 2012
Messages
4,142
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Here is how I structured it.Raw data in A1 to B12 criteria in D1 to E2 and the output in D7


Excel 2010
ABCDE
1NameageNameName
2james16<>charles<>Michael
3jane29
4james22
5kane21
6charles27
7charles28Nameage
8jane21james16
9charles26jane29
10Michael11james22
11james14kane21
12kane13jane21
13james14
14kane13
Sheet6
 

Pinaceous

Well-known Member
Joined
Jun 11, 2014
Messages
784
Office Version
  1. 365
Platform
  1. Windows
Hi Momentman,

I didn't realize you could duplicate headers and omit others in producing a result.

I'll have to try it out.

Would this method work for a 3rd for example?

Many thanks,

-Pin
 
Last edited:

Momentman

Well-known Member
Joined
Jan 11, 2012
Messages
4,142
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Yes it would, see the below


Excel 2010
ABCDEF
1NameageNameNameName
2james16<>charles<>Michael<>kane
3jane29
4james22
5kane16
6charles16
7charles28Nameage
8jane16james16
9charles26jane29
10Michael16james22
11james14jane16
12kane13james14
Sheet6
 

Pinaceous

Well-known Member
Joined
Jun 11, 2014
Messages
784
Office Version
  1. 365
Platform
  1. Windows
Wow Momentman! Thank you. Theoretically, then you can have numerous title heading duplicates for your criteria in producing your desired output and you do not have to represent all of the column headings as part of the criteria.

You have taught me a very valuable lesson. Much appreciated! Many thanks and G-Bless.

-Pin
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,282
Messages
5,836,404
Members
430,425
Latest member
xlsee

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