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