Hello Excel Gurus,
I have 2 questions that I don't even know if there's a solution to it.
Given a range of numbers (below), we can see that 0-1 (6x), 1-2 (5x), 2-3 (4x), 3-4 (3x), 4-5 (6x), 5-6 (5x), 6-7 (6x), 7-8 (2x), 8-9 (3x), 9-10 (2x)
0, 0.1, 0.2, 0.3, 0.4, 1.0,
1.1, 1.2, 1.5, 1.9, 2.0,
2.1, 2.2, 2.7, 2.8,
3.2, 3.5, 3.6,
4.1, 4.3, 4.5, 4.7, 4.9,5.0,
5.2, 5.4, 5.6, 5.8, 6.0,
6.1, 6.2, 6.4, 6.5, 6.8, 6.9,
7.5,7.9,
8.1, 8.8, 9.0,
9.1, 10
The 1st question is that, How do I spit out the no. of occurance in the given range. Which is shown above. i.e. 0-1 (6x), 1-2 (5x), ... ..., 9-10 (2x). Without the 'x' of course.
2nd question is, how to tell the user, what's the range that occured most. In our example, it will spits out 0-1, 4-5 and 6-7 as the answer.
Updated:
Bookmarks