![]() |
|
|
|
#1
|
|||
|
|||
|
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/
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Sorting
|
gilmourlead | Excel | 3 | 02-17-2016 09:27 AM |
Capitalize one to two words if they are the only words on a line
|
jrhlavac | Word VBA | 1 | 10-08-2015 08:19 PM |
Sorting
|
texascpa | Excel | 1 | 07-15-2015 12:22 AM |
How to mark underlined words in a sentence as A, B, C, D (beneath the words)
|
thudangky | Word | 13 | 12-12-2013 02:22 AM |
| Why Words doesn’t show the style of the selected words automatically???? | Jamal NUMAN | Word | 0 | 04-14-2011 03:20 PM |