Forum Discussion
Ability to return a sub-list from a master list?
I am working with a master list that has about 400 rows of data. The first column is an 8 digit number. The first 5 digits of the number define a product line. The last 3 digits identify a unique ...
ECJ53 If you are an MS365 subscriber, your version of Excel might already recognise the FILTER function. If so, the attached workbook contains a working example of what I believe you are trying to achieve.
Using a structured table for the Master list, to make the filtered range extend automatically when you include new items in the master list.