With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, August 6, 2012
yogi_Filter Data In Range For Specified Resource And Unique City
Right now this shows every row of the columns B through W.
Is there anyway that I can filter out rows that have duplicate information in one of the columns? So for example Column C header is "City" and many rows in that column say Santa Fe. I only want the first row that says "Santa Fe". This way I can see each unique entry instead of all the data associated with it.
This spreadsheet should explain what I am looking for.
I am trying to use the Filter function and the Unique function to create the third tab in the example above. I want it to be a dynamic tab so that when I add information to the Data tab that the Ralph tab automatically gets populated with the new data. But I only want to see Unique cities.