Forum Discussion
Solved
Enter data into a table to create a list
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 ...
It 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.
need to create a list based on what we are producing.
What kind of list do you want to produce?
Can you share files rather than screenshots and your expected result?
What kind of list do you want to produce?
Can you share files rather than screenshots and your expected result?