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 looks	How I would like to sort the list
apple	apple
search engine	search engine
text	numbers
numbers	text
sample text	sample text

My working sheet: https://docs.google.com/spreadsheets/d/10vw5NLAJRGFeWa4yCP_oxgM6hGsRT5lFByMDClIbPms/edit#gid=0

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