Filter multiple columns of a survey data as per defined categories

Hi,

I have to filter multiple columns of a survey data to make new categories as per some definitions given in sheet.
How do I create above categories or how should I create autofilters without creating several columns for individual filtered categories (like how I can visualize these 18 categories in a single column, rather than creating 3 or 4 columns for these subsegments wihin high rich or rich). It will also include vlookup to look for these categories based on certain rules

plz find the sheet attached for sample definitions and the sample data, with the query

Pls take a look to forum rules and specially-in this case-to this one.

...if your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

I really don't know if there is another way to do the payment.

I'll let Admin knows about your request!

In the meantime let's hope that someone will be able to help you.

Excel1985,

You can pay through your credit card.