Alright so here's my set up; Collum A contains Client Names, Collum B shows item they order, Collum C shows the number of units of the item.
I want to create a few cells in Collum D that lists all the items (once) and the total of units of each items ordered. I haven't been able to figure out a specific function to do this.
Any ideas?
Why not just use a pivot table?
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks