Formula to find new product and add to list

[empath89]

I would like a formula to grab new products and add them to a list. For example, I have two tabs. In tab A, I keep track of how much we sell/buy by product (so we bought 10 apples and 15 oranges and sold 10 oranges) and in tab B is a sumif formula to add up the sum so we know how much of each product is available as a weekly total is entered in tab A. So, I'd have 10 apples and 5 oranges in that tab. However, how can I create a formula that will recognize when a new product is entered? Say, I have 12 rows in tab A that are just oranges and apples, but then row 13 has a banana. What I would like is a formula in tab B that would recognize all products in column A in tab A once, so we don't have to go in and add it manually to the list of products.

 

[VBE313]

I think you are looking for the =UNIQUE formula that excel just announced recently. Here is a link below describing new dynamic array formulas.
https://www.excelcampus.com/functions/dynamic-array-formulas-spill-ranges/

 

[empath89]

Thank you so much!