How to Create an Inventory Tracker in Excel

[@rickguerrero2282]

Thanks for sharing the trick of "*" for building a complex filter selection.

[@nicholasrunowich371]

Great video - I with Lowes uses the re-ordering philosophy here - you have to wait for the stock to be at zero - before they will re-order !!!!

[@luigibru8677]

You should considered the pcs sold per day for each product

[@jonr6680]

I'm the Dummy the books are for... So is this 'spilling'? What happens if there's something in the cell below the function? So does the return array update and extend without any need for refreshing manually? I guess that's the point so 'yes'? So is the source array dynamic (or could it be, e.g. a table), if you add new items, the function still works and includes the new items? Thanks!