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.
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…