questforexcel
Board Regular
- Joined
- Jan 18, 2019
- Messages
- 128
- Office Version
- 2013
- Platform
- Windows
Hi,
If I have a set of repetitive data i.e. individual data points which fall under the same range cell, is there a way to group them together in excel.
For eg.
All the below data fall under Zone 6. Is there a way I could club all the numbers together for ease of reference. Something like 500-519 would be Zone 6.
Thank you
<colgroup><col><col></colgroup><tbody>
</tbody>
If I have a set of repetitive data i.e. individual data points which fall under the same range cell, is there a way to group them together in excel.
For eg.
All the below data fall under Zone 6. Is there a way I could club all the numbers together for ease of reference. Something like 500-519 would be Zone 6.
Thank you
Dest Zip/Postal Code | Zone |
500 | 6 |
501 | 6 |
502 | 6 |
503 | 6 |
504 | 6 |
505 | 6 |
506 | 6 |
507 | 6 |
508 | 6 |
509 | 6 |
510 | 6 |
511 | 6 |
512 | 6 |
513 | 6 |
514 | 6 |
515 | 6 |
516 | 6 |
517 | 6 |
518 | 6 |
519 | 6 |
<colgroup><col><col></colgroup><tbody>
</tbody>