Hello all
In the provided sample, I sorted column AH than AI by number as you see.
Next I wanted to sort by column C..the issue I am having is column C isn't setup to sort the way I want. I highlighted in blue what I want column C to sort by. But the issue is if I sort by column C, it will sort by 1st/2nd or whatever is at the beginning text of column C.
I thought about using a helper column with the search function or find function than sort the helper column, but the text I actually want to sort by won't always be in the same position in column C nor will it always follow the term 1st/2nd or 3rd (for example row 22 column C begins with t2 rather than row 18 column C begins with 1st t2).
The term I want to sort by in column C will always contain following terms...1 ext,t2,t3,t4...and so on or 1pt,2pt,3pt,4pt & so on. I highlighted in blue these in some of the rows in the provided sample.
So I am wondering what formula I can use to accomplish the sort in Column C the way I want to or perhaps another method such as a different way to sort or the like.
Please let me know any further clarification that is needed.
Bookmarks