Tuesday, July 10, 2012

yogi_Identify Duplicates Exact (Case Sensitive) Or Otherwise (Case Insensitive)

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #618   Jul 10, 2012     www.energyefficientbuild.com.


user Minky1981 said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/_xfh17f-oeE)
quickly identify cells in a column that contain the same exact word so that I can delete the duplicates?
----------------------------------------
following is a solution to the problem where I have marked duplicates considering Exact (case sensitive) and otherwise (case insensitive) as well as instance of occurrence

2 comments:

  1. Thank you for sharing this! It just made my day :)

    ReplyDelete
  2. You Are Very Welcome Per Pettersson ... Now Let us keep Googling.

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete