With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, March 11, 2018
yogi_If A Name In Column A Appears More Than A Specified Number Of Times Replace It With Another String
question by: Mick Stringfellow https://productforums.google.com/forum/#!topic/docs/TxgHh6vAddo;context-place=forum/docs How to replace data if it's repeated 3 times in a column Hi all,
Not sure if this is do-able.
I have a column of data with people names. If a name is repeated 3 times, i need the lowest name in the column to be changed to another word.
Also,there may be more than one word which is repeated 3 times
This link is an editable example. I'm not sure if this is possible but hope it is.
Thank you in advance.
I'm out for a couple of hours so apologies if my reply is delayed.