Forum Discussion
Filter on table and column
Hello, i have two tables, one that has the stock of each product and the second has a cloumn that has the names of the products purchased. each row of this column contain one product purchased, so if...
Hi shady_hamilton,
Maybe something mistake. We cannot see your sample data. Please upload your sample data and the desired output so that we could help further on it.
Best Regards,
Cherry
sorry, not sure what happened, here is the sheets again, First Sheet (purchases) Date Purchases 01/01/2018 Toy 02/01/2018 Toy 03/01/2018 Pen 04/01/2018 Toy 05/01/2018 Book 06/01/2018 pencil 07/01/2018 Pen 08/01/2018 Toy 09/01/2018 pencil second sheet (Stock): Date Purchased Toy Pencil Book Pen 01/01/2018 10 5 6 15 02/01/2018 3 1 4 0 03/01/2018 4 0 4 0 04/01/2018 2 0 1 0