Finding matching numbers in different rows.

C

classic3283

I have a spreadsheet with a list of 20 numbers in each row. What I want to
do is find out if any numbers in the below row, match any numbers in the top
row. Ex:

6,9,10,15,27...
1,3,5,6,10,14...

Next to the 6 in the top row I want to add a column(cell) which tells me how
many times 6 was repeated in the row below it. I have worked with a few
different ideas but so far I have had no luck. Any help on this would be
greatly appreciated.
 
S

Sheeloo

Assuming you have 6 in A1 and your numbers to search for 6 in A2:T2 then in
B1 enter
=COUNTIF(A2:T2,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

Similar Threads

matching numbers 6
Match and delete rows on two different sheets from reference numbers 4
conditional formatting in excel 2007 1
Finding and copying whole rows 1
Excel Conditional Formatting 1
repeated numbers or value 2
moving row data to a colunm in sorted order 9
Find the last row using 2 to 20 criteria 8

Top