Sunday, March 11, 2018

yogi_If A Name In Column A Appears More Than A Specified Number Of Times Replace It With Another String

Google Spreadsheet   Post  #2395

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Mar-11-2018

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.

Mick