Adding and Colating Data

jbmcgarry

New Member
Joined
May 2, 2006
Messages
7
I have a spreadsheet with a large number of items and quantities.

Is there a way to transfer the information onto a separate sheet showing each item name with the total aquantity for that item.
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Watch MrExcel Video

Forum statistics

Threads
1,113,861
Messages
5,544,723
Members
410,630
Latest member
JFORTH97
Top