•2 min read•from 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 |
[link] [comments]
Want to read more?
Check out the full article on the original site
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