Sunmarize list

besttt

New Member
Joined
Apr 17, 2020
Messages
1
Office Version
365, 2019
Platform
Windows, MacOS
Hello, I need help summarize list on people ordering which items. I currently have 50 lists of items and more than 100 people. I’ve done most of the part but it’d be nice if I can show which person order which item and how many in a different sheet. Please do help me.Thank you
41323A79-73AF-45D6-8DC4-097D4DA0F32C.jpeg
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,204
Office Version
2007
Platform
Windows
Hi and welcome to MrExcel.

Do persons already exist on the destination sheet? Or is the sheet empty?
Can it be with a macro or do you want formulas?
 

CA_Punit

Well-known Member
Joined
Nov 18, 2019
Messages
616
Office Version
365
Platform
Windows
Book1
ABC
1Column1AttributeValue
2Person 1A1
3Person 1D2
4Person 2B1
5Person 2E1
6Person 3B1
7Person 3D1
8Person 4C2
9Person 4E1
Sheet4



Will this suffice your requirement
 

Watch MrExcel Video

Forum statistics

Threads
1,102,545
Messages
5,487,494
Members
407,603
Latest member
jortronm

This Week's Hot Topics

Top