I have a data set that follows A1000-A1106. I'm sequencing for warehouse layouts, where you sequence down one aisle and up the next, e.g. A1000-A1106 even would have a sequence running down, A1001-1005 would run back up, so adding a sequence of say 1000 in cell 1, 1100 in cell 2, well it doesn't work as they both increase, one top to bottom, and the other bottom to top. I have quite a bit of data, so filtering is required. I've filtered by Odd, and by the Aisle, e.g. A, B, C, D...but I can't get this data in the cells without doing it manually now. I can't copy and paste the values due to the filters, so sort of lost right now.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Unique sequencing
- Thread starter srooney
- Start date
awoohaw
Well-known Member
- Joined
- Mar 23, 2022
- Messages
- 5,096
- Office Version
- 365
- Platform
- Windows
- Web
welcome to the forum. Please post a small sample of your raw data, and a sample of what your expectations are.
The forum has a tool called xl2bb add in (link below) that allows you to do that. If not please post the data and expectations in TABLES and not an image.
Thanks in advance.
The forum has a tool called xl2bb add in (link below) that allows you to do that. If not please post the data and expectations in TABLES and not an image.
Thanks in advance.
Upvote
0
