View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default 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.