# Advanced Filter - Multi Scenario

#### TheCardiffGiant

##### New Member
Greetings,

I am trying to filter an Excel 2003 spreadsheet. There are two unique scenarios that I need to handle.

First scenario, list contains funds with multiple classes, one of which is called "total," filter the list to return only the fund containing the word "total"

Ex.
Div Growth - Class A
Div Growth - Class B
Div Growth - Class C
Div Growth - Total
Div Growth Fund
Balanced - Class A
Balanced - Class B
Balanced - Class C
Balanced - Total
Balanced Fund

Expected result (filter and return):
Div Growth - Total
Balanced - Total

In the second scenario, the list does not contain the word/class "Total"

Ex.
Emerging Mkts Fund - Class A
Emerging Mkts Fund - Class B
Emerging Mkts Fund - Class C
Emerging Mkts Fund
Income - Class H
Income - Class Y
Income - Class X

If the "total" class is not found, but a class(less) version of the fund is found then return the fund with word "fund" in the name [Emerging Mkts Fund].

If the "total" class is not found, and a fund without the word "fund" in the name and where a class is not present is not found, then filter and return the fund with the highest alpha position class [Income - Class H].

Note that all of these funds (and 1,000+ add'l funds) will be in the same column, in the same spreadsheet, so the solution needs to accommodate all of the above situations concurrently.

Thanks very much for the help.

R

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

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.

1,167,502
Messages
5,854,102
Members
431,619
Latest member
AjaiSpillers

### 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?

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