Formula for searching names from two columns

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

Kindly help in getting excel formula for following table:

column1 Column2

A ABC
A ABC
A ABC
A XYZ
B XYZ
C XYZ
C ABC
C ABC

I want count of column1 unique values with regards to column 2 value.

"A" = 3 (ABC)
"A" = 1 (XYZ)




1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
Best to use pivot tables. another method is to use formula . first you have to find out unique items from column A and B and put it in a matrix format. If there a is big data base you can used advancaed filer to get the uniuqe items.

download the file from this webpage

http://www.speedyshare.com/files/24311978/NAUMANASA.xls

and see the formulas in D13 which is copied to other cells in that matrix;