View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sinner Sinner is offline
external usenet poster
 
Posts: 142
Default Formula for list summary

I have a list below with min & max values. I want a summary in such a
way that the formula calculates the first number in range & last
number and continue for any skiped series.


List

12220
12221
12222
12223
12224
12225
12226
12227
133356
133357
133359
133360
133361
133362
133363
133364
________________________

Result:
Start End Quantity
12220 12227 8
133356 133357 2
133359 133364 6