Compare 2 columns, find a word from 2nd column corresponding to the different values in 1st column and write value in third column

[ashishdabas]

Hi,

I have 2 columns as below:

Column A	Column B
Shopping	ETA
Shopping	ETA
Shopping	RSA
Search	ETA
Search	RSA
Search	RSA
Display	ETA
Display	ETA

I want to find the count of RSA in Shopping, Search and Display in Column A and return the value in third column. E.g Shopping has 1 RSA, Search has 2 RSA and Display has 0 RSA.

Output should be like this:

Column A	Column B	Column C
Shopping	ETA	1
Shopping	ETA	1
Shopping	RSA	1
Search	ETA	2
Search	RSA	2
Search	RSA	2
Display	ETA	0
Display	ETA	0

Please let me know if anything is not clear.

Thanks

 

[Toadstool]

Hi ashishdabas,

Does this do what you want?

AshishDabas.xlsx
	A	B	C
1	Column A	Column B	Column C
2	Shopping	ETA	1
3	Shopping	ETA	1
4	Shopping	RSA	1
5	Search	ETA	2
6	Search	RSA	2
7	Search	RSA	2
8	Display	ETA	0
9	Display	ETA	0
Sheet1

Cell Formulas
Range	Formula
C2:C9	C2	=COUNTIFS($A$2:$A$9,A2,$B$2:$B$9,"RSA")

 

[ashishdabas]

Yes that's exactly what i wanted, thank you.

 

[Toadstool]

Yes that's exactly what i wanted, thank you.

You're welcome!