Excel - Update Counts based on many inputs
Budget: $30 – $250 USD
I have a functional EXCEL spreadsheet that counts a total based on criteria, and shows me the total count for that variable. I want to now take this a step further.
CURRENT FUNCTIONALITY:
* I input many numbers (variables) in a table manually
* A separate sheet checks these manual inputs, and gives me a total count that each variable shows up
NEW FUNCTIONALITY
* Translate this output (total count) sheet to an intelligent summary (currently I show cells for variables that don't show up, they just show a "ZERO" under it). I want this new table to only show variables that exist, and skip ones that don't. I want these to show in order from largest to smallest in a table row by row. If a variable doesn't show up in the manual input, then it should not show up on the output TOTAL COUNT table. This will be the TOTAL INPUT COUNT NUMBER
* Next, I want to sheet to check elsewhere in the book to see how many of that number show up. This will be the TOTAL OUTPUT COUNT NUMBER.
* I then want the TOTAL OUTPUT NUMBER to AUTO DEDUCT from the TOTAL INPUT NUMBER and show me a balance.
* The result should be that the manual inputs are counted for their totals, then the manual output numbers will subtract from this total.
I need the sheet to tell me HOW MANY OF A NUMBER I NEED, and then tell me HOW MANY LEFT I NEED TO ACCOUNT FOR. This table will be used to determine of ALL ITEMS HAVE BEEN ACCOUNTED FOR and help us quickly identify a balanced order sheet.
CURRENT FUNCTIONALITY:
* I input many numbers (variables) in a table manually
* A separate sheet checks these manual inputs, and gives me a total count that each variable shows up
NEW FUNCTIONALITY
* Translate this output (total count) sheet to an intelligent summary (currently I show cells for variables that don't show up, they just show a "ZERO" under it). I want this new table to only show variables that exist, and skip ones that don't. I want these to show in order from largest to smallest in a table row by row. If a variable doesn't show up in the manual input, then it should not show up on the output TOTAL COUNT table. This will be the TOTAL INPUT COUNT NUMBER
* Next, I want to sheet to check elsewhere in the book to see how many of that number show up. This will be the TOTAL OUTPUT COUNT NUMBER.
* I then want the TOTAL OUTPUT NUMBER to AUTO DEDUCT from the TOTAL INPUT NUMBER and show me a balance.
* The result should be that the manual inputs are counted for their totals, then the manual output numbers will subtract from this total.
I need the sheet to tell me HOW MANY OF A NUMBER I NEED, and then tell me HOW MANY LEFT I NEED TO ACCOUNT FOR. This table will be used to determine of ALL ITEMS HAVE BEEN ACCOUNTED FOR and help us quickly identify a balanced order sheet.