Adding data to create ranges
Hello!
I want to calculate the number of bagtags in my excel sheet and have the
result come out in ranges. Can you please help me create a formula for this?
Note: a cell may also have a value of 0. I would like the formula to
result in a blank cell when the value is zero.
Sample:
Would like formula to create range
Sacks Bagtags
24 1-24
1 25
6 26-31
27 32-58
5 59-63
5 64-68
5 69-73
32 74-105
1 106
--
Thanks!
Jodie Gardner
|