How to count the number of times a number is repeated in a column

M

Mark A

I want to count (sum) the number of times any number is repeated in a column. Any ideas for a formula to do this? Column F: Range F2-F1958. I have been trying multiple iterations with COUNTIF for hours w/o success.
 
P

Paul Hyett

I want to count (sum) the number of times any number is repeated in a
column. Any ideas for a formula to do this? Column F: Range F2-F1958. I
have been trying multiple iterations with COUNTIF for hours w/o success.
Click to expand...
I would probably use the FREQUENCY function for this, unless it needs to
be dynamic? I tend to use the Countif method if instant total update is
what I need, though.
 
R

Ron Rosenfeld

I want to count (sum) the number of times any number is repeated in a column. Any ideas for a formula to do this? Column F: Range F2-F1958. I have been trying multiple iterations with COUNTIF for hours w/o success.
Click to expand...

Try:

=SUMPRODUCT(--(FREQUENCY(Rng,Rng)>=2))

where Rng = F2:F1958
 

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

SUMIFS UNTIL the number is repeating 0
SUMIFS ONLY UNTIL the number REPEATS 1
Counting the Number of times the Slides are visited 0
How to count the numbers in a Word document? 0
Autonumber field in Excel that behaves the same as Access 0
Count in a range of numbers 9
Count Number of Unique Cells That Don't Have Certain Characters 0
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2

Top