Thursday, August 9, 2012

yogi_Extract Duplicated Non_Duplicated Listed_Once Entities From a List

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #681   Aug 09, 2012     www.energyefficientbuild.com.

user GOOGLE DOCS is BOSS said: (http://productforums.google.com/forum/?zx=h8qtnhw8eych#!category-topic/docs/spreadsheets/DvWxMadJk_E%5B1-25%5D
How do I list ONLY duplicate cells? Please help :) I have an example listed! 
Thank you very much for your help in advance!!
I am trying to create a column (see D), that lists ONLY duplicate instances of cells from another column (A:A).  For example, I am trying to recreate the results of column D.  
Column D should only list results from column A:A that appear more than once.  Thus, the data from from A2 does not appear in column D, as A2's data was only listed once.
Thank you to any who can help me!! :P

                       A                               B                                  C                                    D
1           111 Smith Drive                                                                                     111 Smith Drive

2           413 Joe St                                                                                             444 Dave Place

3           444 Dave Place                                                                                      

4           111 Smith Drive

5           111 Smith Drive

6           444 Dave Place

7           444 Dave Place

----------------------------------------------------------------------------------------------------
following is a solution to the problem that the user asked and then to a bit more generalized problem


No comments:

Post a Comment