Formula to find new product and add to list

empath89

New Member
Joined
Oct 30, 2018
Messages
6
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.
 

Forum statistics

Threads
1,085,564
Messages
5,384,465
Members
401,902
Latest member
lilytran14

Some videos you may like

This Week's Hot Topics

Top