ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Combining multiples and creating a range of numbers (https://www.excelbanter.com/new-users-excel/350553-combining-multiples-creating-range-numbers.html)

RMN

Combining multiples and creating a range of numbers
 
I have a list of data that looks something like this:
1 Cats
2 Cats
3 Dogs
4 Dogs
5 Dogs
6 Birds
7 Birds

And I want to find a way to combine multiples and have the numbers become a range, like this:
1-2 Cats
3-5 Dogs
6-7 Birds

Here's an example of what I mean: https://docs.google.com/spreadsheet/...1TnNwdlgyR Wc

I would do it by hand, but there's 45,000 rows so it would be pretty time consuming. Any ideas?


All times are GMT +1. The time now is 04:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com