B
Benjamin
I have a list with people, day, qty. How can I get a list that only has
people and the total qty per person?
people and the total qty per person?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
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?
One way: Create pivot, people into ROW area, qty into DATA area (as sum)
B
Benjamin
Is there a Macro to do this?
Max said:One way: Create pivot, people into ROW area, qty into DATA area (as sum)
M
Max
Benjamin said:Is there a Macro to do this?
You could record a macro when you construct it manually