Forum Discussion
Creating a list from a master list
I have been looking around and can not seem to find the exact thing I need. So I have a sheet I use to estimate roofing with. I got a list of products with prices and quantities. My goal is to get ...
IF you have Excel 365 then you can use FILTER so
=FILTER(Main!A:B, isnumber(Main!A:A), "")
or preferably if the MainTable is formatted as a table then:
=FILTER(MainTable[[Quantity]:{DESCRIPTION]], isnumber(MainTable[Quantity]), "")
if you don't have Excel365 then i suggest using a Pivot Table
Format the Main table as a table and choose insert pivot table
Then you select the source table and destination on the 2nd sheet
Then Select the 2 columns and filter by quantity > 0.
If you have problems, attach a sample and we can show you how.
=FILTER(Main!A:B, isnumber(Main!A:A), "")
or preferably if the MainTable is formatted as a table then:
=FILTER(MainTable[[Quantity]:{DESCRIPTION]], isnumber(MainTable[Quantity]), "")
if you don't have Excel365 then i suggest using a Pivot Table
Format the Main table as a table and choose insert pivot table
Then you select the source table and destination on the 2nd sheet
Then Select the 2 columns and filter by quantity > 0.
If you have problems, attach a sample and we can show you how.
Thank you, I will start attempting this route. I will update once completed.