| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating summary from a list | Excel Worksheet Functions | |||
| Creating a Detailed List from a Summary List | Excel Worksheet Functions | |||
| Creating A Breakout List from a Summary List | Excel Discussion (Misc queries) | |||
| Pulling a Summary List from a Larger List | Excel Discussion (Misc queries) | |||
| Summary List?? | Excel Discussion (Misc queries) | |||
Threaded Mode
