Hello folks!



I'm working on a large excel sheet (for articles categorization work) and one of the columns I defined is "Field".

Under "Field", there are several fields to choose from (for instance: PV, CSP, etc').

I have some articles that need be tagged with 2 fields (for instance: PV and CSP).

If I write "PV + CSP" in the cell under the "Field" column, and use the Sort option in Excel, a new category will be added to the list - "PV + CSP". That's what I don't want to happen.

So my question is: can I write 2 (or more) words, that won't create a new sub-category in the Sort list? In my aforementioned example, I want the user to find that article by sorting with PV and CSP tags, seperately.

Thanks!

You lost me here. Do you mean a filter list? Maybe you should try to explain what you are trying to do. There may be a better way.

Hi - whenever you add different text values to a filter list it will add these as entries in the sort column. Unfortunately this is unavoidable.

Potentially - you can create two different columns/fields:
- 'PV 'Column - flags whether the line has the tag 'PV' (e.g. with '1' or '0')
- 'CSP' column - flags whether the line has the tag 'CSP' (e.g. with '1' or '0')

This way each column can have only two potential options (1 or 0)

You can also find rows which have both PV & CSV by applying filter = 1 to both columns

I've added a GIFCoach to demonstrate this, if it helps
https://www.gifcoach.com/how-to/appl...crosoft-excel/