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