Count

[mks]

Hi,

I have the repeated data in columns. I wants to count them if both cells data match. for Example - Column "A" has grade A & B from range (A10:A120) and Column "B" has the name ( John & Mike) from Range (B10:B120). I want to count in Cell A125 that if John matches grade "A" from column A and for the same for Mike for Grade "B" in cell A126.

Thanks for your help.

mks

 

[Aladin Akyurek]

Hi,

I have the repeated data in columns. I wants to count them if both cells data match. for Example - Column "A" has grade A & B from range (A10:A120) and Column "B" has the name ( John & Mike) from Range (B10:B120). I want to count in Cell A125 that if John matches grade "A" from column A and for the same for Mike for Grade "B" in cell A126.

Thanks for your help.

mks

Try to post a small sample along with the results you want to see.