Hi, I would like to be able to count the number of users which fall in to progressive slabs as below:
SLAB_A (1 to 10 users)
SLAB_B (11 to 20 users)
SLAB_C (21 to 200 users)
SLAB_D (201 to 500 users)
As some examples, the counts should be:
User count of 5, SLAB_A = 5, and the other slabs would be 0.
User count of 15, SLAB_A = 10, SLAB_B = 5, and the other slabs would be 0.
User count of 100, SLAB_A = 10, SLAB_B = 10, SLAB_C= 180 and the remaining SLAB_D would be 0.
User count of 202, SLAB_A = 10, SLAB_B = 10, SLAB_C= 180 and the remaining SLAB_D = 2.
I have set my columns out on my spreadsheet as
[Start], [End]
1, 10
11, 20
21, 200
201, 500
I would like a user count for each slab row, slabs may be added in future so ideally it would need to be flexible.
Any ideas how I would do this please?
Bookmarks