Thanks in advance for anybody who can help here. On the attachment, data set A is one file and data set B is another file, but for this purpose I just put them on the same worksheet.
As the instructions say, I'm just looking to take data that looks like data on the left and turn it into data that looks like what you see on the right. But when it is extrapolated, it has to know which sizes are missing from a set of sizes. The set of sizes here is 5,6,7,8,9,10. Below the line for the shoe, it then needs to put the missing sizes in the format in yellow.
Thanks for any help you can provide!!!
Hello gkimmer,
The problem with either extrapolating missing numbers from a sequence or determining which are missing from look up list is defining the lower and upper boundaries of the list to be compared. For example, your comparative list of shoe sizes. What you list is whole sizes only. Realistically, we all know half sizes are also stocked. How do we know that size 5 is the smallest and size 10 the largest that are stocked? How would these limits be determined for other stocked items?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks for the reply. This shoe manufacturer only does whole sizes. But for this purpose let's assume there are 5.5, 6.5, 7.5 and 8.5 available. Whether whole or half sizes, how can I best have Excel automatically know what is missing from each style of shoe once a new inventory file is generated? Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks