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
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/6wWmAIpf27k;context-place=mydiscussions
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
appleapple
search enginesearch engine
textnumbers
numberstext
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