Can I do custom filter in multiple columns?

Can I do custom filter in multiple columns?
Please refer to the file attached for expected output.

The way you are trying to do it - no.

What are you filtering on - duplicate entries?

From the looks of your data, you will never get BB1 on column B to show if it has CC1 next to it and you dont want CC1 shown

Just to add in...when you filter data, an entire row is hidden (or shown), not just part of it

Can I used the following method?

Step 1 Remove value without prefix "AA" and "BB"
Step 2 Delete all blank cell resulted from step 1

Please advise how to do for each step
Thank you in advances.

N.B. Edited requirements to simplify the problem

how about this solution.

See the bleu cells and then filter out CC

Hi oeldere,

Your solution is great. You are my hero.
This can also be done in reverse way by removing value without prefix "AA" and "BB".

Could you please tell me steps to do it?

Like
1. Transform data to the vertical view:...
2. Filter steps:... Then,...
3. Transform data back to horizontal view:...

Therefore, I can work with 400+ columns and 200+ rows

Thank you in advances.

Therefore, I can work with 400+ columns and 200+ rows

Then show us an excel file to work with.

Please also add the expected result in your file.

To re-arange the 400 columns I will use VBA.

Is this an acceptable alternative?

Here is the code to rearange the data.

Please Login or Register  to view this content.

It's great.

If I would like to add more filters such as EE, FF in addition to AA and BB, where I can put it on your code?

Can I put the rest of data from filters to 3rd sheet?

Just for my knowledge, could you please tell me steps that you have done without VBA coding on 02 07 2016?

Thank you and have a nice day.

First of all, did you tried my code?

What was the result?

If I would like to add more filters such as EE, FF in addition to AA and BB, where I can put it on your code?

Then anser your question in #11 yourself and post it on this forum.


On 02-07-2016 I did not use any code, i just re-aranged the data manualy to show you.

It's great.
Could you please provide me VBA that transform back from the vertical way to horizontal alignment (original)?
Thank you and have a nice day

Although I think you don't answer my questions in #12, I will answer yours

Could you please provide me VBA that transform back from the vertical way to horizontal alignment (original)?

After running the VBA code the original data stays in the same format (horizontal).

I think you don't run the VBA code, am I right?

See my comment in #8

Then show us an excel file to work with.

Please also add the expected result in your file.

You're welcome. We appreciate the feedback!

Thanks for marking the thread solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.


It'd also be appreciated if you post your solution on this forum, so other forummembers also can learn from it.

I have added a reputation to your profile.

I did not receive a rep.

thanks for the rep.