Advanced Filter - Multi Scenario

TheCardiffGiant

New Member
Joined
Aug 10, 2010
Messages
1
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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Watch MrExcel Video

Forum statistics

Threads
1,133,156
Messages
5,657,158
Members
418,363
Latest member
Debating_Earth

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