Google Spreadsheet Post #1104
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr 10, 2013
user Robert Warner :(http://productforums.google.com/forum/?zx=ik561dw2e7n8#!mydiscussions/docs/3cLYffOYn9Y)
Remove duplicate values and subsequent rows
I have a large table with duplicate values in column A but unique values in subsequent columns. However, I want to remove any rows that have duplicate values in column A, though may not have duplicate values in subsequent columns (b through f e.g.). I don't care which row is saved. Is this possible? The unique() function doesn't work because there are unique values in the other columns.