• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sorting range using text contents as criteria

S

Shan

New Member
Is there a way to sort a range of text data by specific criteria ie a word? Eg If A1:A100 contains various text data which may/may not contain the words 'tax', is it possible to sort the data in such a way that all words containing 'tax' appear at the top of the range??
 
Shan

Select your data area and convert it to a Table

Excel 2007, Insert, Table

Select the Field dropdown for the field containing the words you want to sort by

Goto Text Filters, Contains and use the word Tax
 
You must log in or register to reply here.
Back
Top