Find Partial text Match
Closed
mghore
Posts
1
Registration date
Thursday 29 March 2018
Status
Member
Last seen
29 March 2018
-
29 Mar 2018 à 17:59
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 3 Apr 2018 à 11:35
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 3 Apr 2018 à 11:35
Related:
- Find Partial text Match
- Partial match excel - Guide
- Music match jukebox - Download - Audio playback
- Tinder match disappeared - Guide
- Csgo custom match commands - Guide
- Royal match free download - Download - Puzzle
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
3 Apr 2018 à 11:35
3 Apr 2018 à 11:35
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
