Excel Tutorials: Track Your Inventory Like a Pro

Описание: Calling all my small-business owners and corporate millennials, this Excel function is for you! Watch me separate inventory between products we have in stock and those we don't with this formula in seconds.👩‍💻

✨Formula
In stock → =FILTER(B3:B22,C3:C22 more tan 0)
Out of Stock → =FILTER(B3:B22,C3:C22 less or equal to 0)

💬 Let me know in the comments section if it worked for you

📲 Share with a friend who also wants to improve their Excel skills

💚 Level up your Excel game and your career. Hit the plus for weekly tutorials