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     www.energyefficientbuild.com.   Aug-14-2014
post by Ross Overacker:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/RTPEXKBKVOw)
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

------------------------------------