In excel we have two instances of names in a column. I need each name to give me a SUM calculation and an alert.
I will give you an example:
Name Qty Cell
Test 1 5 A3
Test1 5 A4
Test2 4 A5
Test2 3 A6
I would like the SUM of A3:A4 and A5:A6. When either name, Test 1 or Test 2, reaches 10 first i will get a alert at cell H3.
Can you help me with this. If you need further information let me know.