Thursday, August 14, 2014

yogi_Pull Unique Set Of Entries In Columns A And B Into Columns D And E

                        Google Spreadsheet   Post  #1729
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Aug-14-2014
post by Ross Overacker:
Search for unique values, then return the adjacent cell value
I have two columns of data, with many duplicates in each. The first column contains the data I would like to search for unique values, and the second column adjacent to the right is the value I would like to display. 

In essence what I am doing is taking two columns with many duplicates each and trying to compress it down. The first column contains a package number, the second column contains a count for all items under that package. 

I need each unique entry from the package number column, and the value directly to the right of it.

If I use unique in both columns, all the counts with ZERO below the first are not counted as unique, so they are discarded. 

Thanks for your help
Attachments (1)
Data Compression.ods
5 KB   View   Download