View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jodieg jodieg is offline
external usenet poster
 
Posts: 15
Default 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