Hello,
I'm trying to figure out what would be the best way to sort by section and then determine if it is odd or even.
I believe that this can be done with =MID but I can't get the syntax quite right to pull the section value.
Example:
Aisle Section Location
11 | 098 (even) | A1
11 | 101 (odd) | A2
11098A1
11098A2
11100A1
11100A2
11101A1
11101A2
Than you !
Welcome to the forum.
Can you post a sample workbook with the before state and the proposed after state? I am a little confused on your request in the post.
See my signature on how to attach a sample workbook to the forum.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Sample attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks