 You need to know this tip if you want to save time and manage your inventory in Excel. We're gonna first start with the in stock column. So we'll do equals and then the function filter, open brackets, then select the column containing your product name, comma, then the column containing your units. And the logic we're gonna use here is greater than zero. So any item that has a quantity of greater than zero are in stock. We're then gonna populate the outer stock column with our same function, selecting the product name and again the units column. This time however, our logic is gonna be less than or equal to zero. This way we'll also pick up items that have a negative number. Hit enter and you can now see our outer stock items have been listed in addition to our in stock. Now that the filter has been added to both columns, we can manage our stock and you can see how the inventory is updated in the applicable in stock or out of stock columns. Please don't forget to like if you enjoyed this video.