Dec 06 2023 05:30 AM
I am trying to streamline some of our processes. I have a table of lengths and grades for our product, and I need to create a list based on what we are producing. I want to be able to put numbers in the table, and it automatically produces the list based on that. Using either macros, formulas or a combination of both. I've attached the image of what the table looks like, and an example of what the list could look like. The list then gets printed and tallied as we create the product
Dec 06 2023 08:48 PM
Dec 08 2023 08:40 AM
SolutionIt would have been a little less effort if you had attached a workbook with that first sheet, rather than attaching an image.
The workbook I have attached requires Excel version 365 (or Excel for the web), as it uses the new LAMBDA function (another description is here) and MAP function.
As I interpret it, your column A data contains your product grade. But that interpretation might not be correct; hence the question marks on a couple of my worksheets.
The worksheets whose names end with " (2)" are easier-to-understand versions of how I constructed the "Row-priority List" and "Column-priority List" worksheets; the latter seems to be what you want.
Be sure to read the notes on the _Info worksheet.
Dec 10 2023 05:49 PM
Dec 08 2023 08:40 AM
SolutionIt would have been a little less effort if you had attached a workbook with that first sheet, rather than attaching an image.
The workbook I have attached requires Excel version 365 (or Excel for the web), as it uses the new LAMBDA function (another description is here) and MAP function.
As I interpret it, your column A data contains your product grade. But that interpretation might not be correct; hence the question marks on a couple of my worksheets.
The worksheets whose names end with " (2)" are easier-to-understand versions of how I constructed the "Row-priority List" and "Column-priority List" worksheets; the latter seems to be what you want.
Be sure to read the notes on the _Info worksheet.