excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi,
is there's a formula for finding which number in a range, say a1:a1000, repeat itself the most,
and how many times?
example: (the actual data contains numbers only but longer)
1
2
1
2
1
3
4
5
6
2
3
1
3
2
2
2
1
is there's a formula for finding which number in a range, say a1:a1000, repeat itself the most,
and how many times?
example: (the actual data contains numbers only but longer)
1
2
1
2
1
3
4
5
6
2
3
1
3
2
2
2
1