Excel wizardness needed - Group By, Sort, Count function help
- by Chris
Riddle me this:
You have 3 part numbers with the same part name xyz, each with a quantity of 10 items. The items can be picked during the day or week, therefore changing the amount of items on hand. I know I need to use the group by, sort, count and perhaps sumif formulas to have a running count of the number of items on hand at the end of each day (which could be positive or negative).
Help?
it wont let me add an image because i'm a new user. 'Oops! Your edit couldn't be submitted because:
* we're sorry, but as a spam prevention mechanism, new users aren't allowed to post images. Earn more than 10 reputation to post images.
'