Thursday, April 11, 2013

yogi_Pull Unique Pairs From A Table Of Two Columns


                                          Google Spreadsheet   Post  #1111
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 11, 2013
user rajvivek :(http://productforums.google.com/forum/?zx=kt0soilg3ufa#!category-topic/docs/spreadsheets/cX81KCe8t9I)
How to find unique pairs out of two columns
Hi!

I have a list consisting of two columns which may contain duplicate data, but I need to pull out all unique entries across the two columns.

For example if I have in Column A & B...
  • Stan 28
  • Bob 11
  • Stan 12
  • Bob 11
  • Stan 28
  • Bob 11
  • Dorris 14

I only want to see the unique combinations of the two colums in another two columns C & D and with their no. of times they occur in original dataset in column F as ...
  • Stan 28  2
  • Bob 11  3
  • Stan 12 1
  • Dorris 14 1
Thanks in advance!
------------------------------------------------------------------------------------------------------------

following is a solution to the problem