Filtering multiple criteria with single value

[OnlyTheSnake]

Hi, I'm trying to filter some data that is basically in two columns, a string and a value, for e.g.:

A	1
B	2
C	3

The problem is, C is a supergroup that actually means A & B, but they both have the same value. Rather than maintaining duplicate rows for A & B every time there is a C, I was wondering if it is possible to have a filter such that when A is selected, it will show values for both A & C, ideally without using VBA.

Does anyone have any ideas?

[newdoverman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[OnlyTheSnake]

Ok here's a sample dataset:
Sample.xlsx

[Czeslaw]

Something like this.

[OnlyTheSnake]

Hi Czeslaw, thanks for your response. Could you explain how the formula works? How do I make it simple for the user such that they just have to type in "A" for example and it gives them the desired result? Different people will be looking at the data and will each want to look at their own markets.

[Czeslaw]

See the application and Name Manager.