count, frequency

  • Thread starter Thread starter cathal
  • Start date Start date
C

cathal

I have a column with 50 distinct numbers on it [call it col 1], anothe
spreadsheet has 1000's of numbers in a column [call it col 2], many o
which are duplicates. I want to find a way to count the number o
times all the numbers in col 1 appear in col 2. In other words
something like 50 numbers appear 200 times.

As usual all suggestions welcomed - thanks, cathal.
 
Hi
try the following array entered formula (entered with CTRL+SHIFT+ENTER)
=SUM(COUNTIF(B1:B1000,A1:A50))
 
Frank, thanks for the advice. Another poser: how can I count th
frequency of numbers in col 1 relative to col 2? - catha
 
frank, say I have the following numbers (in col 1 -
375
384
410
427
432
440
445
etc.
etc.

I want to see how often these numbers appear in column 2 [colum
containing 1000's of duplicate numbers, plus many unique numbers]

thanks - catha
 
Hi
if these values are stored in column a you may enter the following in
column C to count the occurence of each number in column A within
column B
=COUNTIF($B:$B,A1)
and copy down
 
Back
Top