counts repeated number in two seperate area


sierra spiegel

I have a formula:

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



T. Valko

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:


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