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.

Thursday, August 14, 2014

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

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.