Surprise Me!

Can Excel be used for inventory management? - Excel Tips and Tricks

2025-10-09 3 Dailymotion

Can Excel be used for inventory management? Yes. Here's how you can do it in a very crude way.

Here are the formulas outlined in the video.

In Stock
=FILTER(A3:A34,B3:B34>0)

Out Of Stock
=FILTER(A3:A34,B3:B34