Wednesday, April 10, 2013

yogi_In A Table of names And Addresses Pull Only The First Instance of A Name And The Associated Address


                                          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.
Thanks for your help
Rob
---
So I can't share the original file (it's confidential), but here's an example of what I want:

Before                                                     After
Name Address                 Name  Address
Bob 123 east st.   ======> Bob 123 east st.
Jim 123 west st.                 Jim 123 west st.
Jim 123 North st.                 Sarah 123 south st.
Sarah 123 south st.

Where after running the formula (which formula I don't know), I've removed the second entry for Jim, and the subsequent values have remained allied with their original values. Does that make sense?
----------------------------------------------------------------------------------------------------------
following is a solution to the problem


No comments:

Post a Comment