EwatchesUSA
New Member
- Joined
- Apr 12, 2011
- Messages
- 15
Hi, I have one list in worksheet A that looks like this
H424-26 Maui Jim
HT208-02 Maui Jim
HT423-11 Maui Jim
H424-26 Maui Jim
26-214 Oakley
09-664 Oakley
26-214 Oakley
117-02 Maui Jim
I need Formula to transfer this data to new work sheet and count how many times it sees each product, this way every time we add more items to spreadsheet A spreadsheet B should only have each style listed only once and add quantities, Please advise.
Regards Mike
H424-26 Maui Jim
HT208-02 Maui Jim
HT423-11 Maui Jim
H424-26 Maui Jim
26-214 Oakley
09-664 Oakley
26-214 Oakley
117-02 Maui Jim
I need Formula to transfer this data to new work sheet and count how many times it sees each product, this way every time we add more items to spreadsheet A spreadsheet B should only have each style listed only once and add quantities, Please advise.
Regards Mike
