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/