Find Partial text Match
Closed
mghore
Posts
1
Registration date
Thursday March 29, 2018
Status
Member
Last seen
March 29, 2018
-
Updated on Mar 30, 2018 at 12:11 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 3, 2018 at 11:35 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 3, 2018 at 11:35 AM
Related:
- Find Partial text Match
- Music match jukebox - Download - Audio playback
- Excel partial text match between two columns - Guide
- Conditional formatting if two cells match ✓ - Excel Forum
- Excel match two columns and output third ✓ - Excel Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Apr 3, 2018 at 11:35 AM
Apr 3, 2018 at 11:35 AM
Hi Mghore,
"I have over 500 rows of data that needs to be filtered on the value listed in column B. "
Why don't you split your data? Put the SWDP value in column A and the text behind it in column B. Now select a cell in your table and goto the Data ribbon and select Filter. This will place a drop down list on the headers. Now you will be able to filter on any SWDP value you want.
Best regards,
Trowa
"I have over 500 rows of data that needs to be filtered on the value listed in column B. "
Why don't you split your data? Put the SWDP value in column A and the text behind it in column B. Now select a cell in your table and goto the Data ribbon and select Filter. This will place a drop down list on the headers. Now you will be able to filter on any SWDP value you want.
Best regards,
Trowa
