2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Counting Numbers That Aren't Unique

With the number listed at the bottom, what equations can I use to count how many number are duplicate, triplicate, etc.? I've done it manually, so I know the results are as follows: duplicate numbers = 11, triplicate numbers = 2, quadruple or more = 3.

2 16 29 52 70 86
8 17 30 52 71 86
9 18 32 53 71 89
10 19 32 54 72 89
11 20 34 54 73 90
13 20 36 57 74 91
14 22 41 58 74 92
14 22 41 58 74 92
14 23 44 59 74 94
14 25 46 60 76 97
14 26 47 62 77 98
15 26 48 64 78 100
15 26 49 65 79
15 27 50 66 82
15 27 51 68 85
15 28 52 69 85
submitted by /u/framosbusot
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#duplicate
#triplicate
#quadruple
#count
#numbers
#equations
#manual
#results
#non-unique
#frequency
#list
#analysis
#data
#values
#Duplicate count