Tuesday, October 10, 2017

yogi_Sort Items In Column A Into Column B With Formula Entries On Top

Google Spreadsheet   Post  #2266

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Oct-10-2017
Question by Stefan.B
How can I sort the words that have hyperlink (like the example below):

I need your help!

How the list looksHow I would like to sort the list
search enginesearch engine
sample textsample text

Thaaank youuu for reading my question, I apreciate if you would help me out, please!

I can not check using a formula whether an entry is a hyperlink, so I have done the next best thing ... check whether an entry is a formula
So because Stefan.B's question is strictly regarding hyperlinks, my following solution may or may not work for Stefan.B