Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-26-2017, 01:39 AM
GIFCoach.com GIFCoach.com is offline Sorting 2 or more words Windows 10 Sorting 2 or more words 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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting 2 or more words Sorting gilmourlead Excel 3 02-17-2016 09:27 AM
Sorting 2 or more words 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 2 or more words Sorting texascpa Excel 1 07-15-2015 12:22 AM
Sorting 2 or more words 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft