Finding matching numbers in different rows.
 

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.

Finding matching numbers in different rows.
 

Assuming you have 6 in A1 and your numbers to search for 6 in A2:T2 then in
B1 enter
=COUNTIF(A2:T2,A1)

"classic3283" wrote:

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.