B Benjamin Apr 11, 2008 #1 I have a list with people, day, qty. How can I get a list that only has people and the total qty per person?
I have a list with people, day, qty. How can I get a list that only has people and the total qty per person?
M Max Apr 11, 2008 #2 Benjamin said: I have a list with people, day, qty. How can I get a list that only has people and the total qty per person? Click to expand... One way: Create pivot, people into ROW area, qty into DATA area (as sum) ---
Benjamin said: I have a list with people, day, qty. How can I get a list that only has people and the total qty per person? Click to expand... One way: Create pivot, people into ROW area, qty into DATA area (as sum) ---
B Benjamin Apr 11, 2008 #3 Is there a Macro to do this? Max said: One way: Create pivot, people into ROW area, qty into DATA area (as sum) --- Click to expand...
Is there a Macro to do this? Max said: One way: Create pivot, people into ROW area, qty into DATA area (as sum) --- Click to expand...
M Max Apr 11, 2008 #4 Benjamin said: Is there a Macro to do this? Click to expand... You could record a macro when you construct it manually ---
Benjamin said: Is there a Macro to do this? Click to expand... You could record a macro when you construct it manually ---
