counts repeated number in two seperate area


S

sierra spiegel

I have a formula:
IF(COUNTIF(A2:C6,A1)

The problem is that i need to search in two areas. The above formula only search the whole area without breaking an area.

For example to what I want:

A1 4 6 8 9 10
A2 5 6 23 44 50
A3 4 7 8 9 22
A4 7 3 1 2 8

I want to search row A2 and A4 only to see if any number matches with any number in A1.

Thank you very much!!!!

EggHeadCafe - Software Developer Portal of Choice
Generic GetXmlReader Data Access Method
http://www.eggheadcafe.com/tutorial...d-b6ebb3575e5e/generic-getxmlreader-data.aspx
 
Ad

Advertisements

T

T. Valko

IF(COUNTIF(A2:C6,A1)
I want to search row A2 and A4

A2 and A4 are not rows, they're individual cells.

Based on the above formula maybe this is what you want:

=COUNTIF(A2:C2,A1)+COUNTIF(A4:C4,A1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top