yogi_Count How Many Times Cell In Column A Match Cell in Column B

                                          Google Spreadsheet   Post  #1203
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 20, 2013
user Robert Warner (http://productforums.google.com/forum/?zx=ttx1g8rgpf8v#!category-topic/docs/spreadsheets/37hRyo8VFWY)
Count how many times cell in column A match cell in column B
I want a sum of the number of times a cell in one column matches a cell in the same row but in a different column. For example, I have 2 columns with 3 different possible values (employee, manager, owner), and I just want to know how many times value in the first column matches the value in the second. Is this possible without having a third column without having a column full of countifs and summing it there?

Thanks for your help!

Rob

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

following is a solution to the problem

yogi_In A Table of names And Addresses Pull Only The First Instance of A Name And The Associated Address

                                          Google Spreadsheet   Post  #1104
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 10, 2013
user Robert Warner :(http://productforums.google.com/forum/?zx=ik561dw2e7n8#!mydiscussions/docs/3cLYffOYn9Y)
Remove duplicate values and subsequent rows
I have a large table with duplicate values in column A but unique values in subsequent columns. However, I want to remove any rows that have duplicate values in column A, though may not have duplicate values in subsequent columns (b through f e.g.).  I don't care which row is saved.  Is this possible? The unique() function doesn't work because there are unique values in the other columns.

Thanks for your help

Rob

---

So I can't share the original file (it's confidential), but here's an example of what I want:

Before                                                     After

Name Address                 Name  Address

Bob 123 east st.   ======> Bob 123 east st.

Jim 123 west st.                 Jim 123 west st.

Jim 123 North st.                 Sarah 123 south st.

Sarah 123 south st.

Where after running the formula (which formula I don't know), I've removed the second entry for Jim, and the subsequent values have remained allied with their original values. Does that make sense?

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

following is a solution to the problem