Thread: [Solved] Sorting 2 or more words
View Single Post
 
Old 03-26-2017, 01:39 AM
GIFCoach.com GIFCoach.com is offline Windows 10 Office 2016
Novice
 
Join Date: Mar 2017
Posts: 4
GIFCoach.com is on a distinguished road
Default

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/
Reply With Quote