comparison of data in two columns
Posted by DAS on September 06, 2001 12:51 PM
I have data in two columns. I want to count how many times a specific value shows up in column "a" and then if that same value shows up in the same row in column "b".
I'm using excel 97.
Thanks.
Posted by Barrie Davidson on September 06, 2001 12:55 PM
So you only want to count this lookup number if it exists in the same row in column A and column B?
Barrie
Barrie Davidson
Posted by Aladin Akyurek on September 06, 2001 1:03 PM
Lets say that the specific value of interest is in C1:
=SUMPRODUCT((A1:A25=C1)*(B1:B25=C1))
will give you a count of cells in A and in B which have the same "specifc value".
Aladin
Posted by DAS on September 06, 2001 1:08 PM
That is correct.
Posted by Barrie Davidson on September 06, 2001 1:12 PM
See Aladin's answer (NT)
