Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting and adding
I have a spreadsheet that has multiple items that are same i.e.(lists are presorted) Item quan type Red 15 625 Red 14 625 Red 12 625 Red 8 625 Red 10 125 Red 9 125 Red 7 125 Red 6 125 Green 100 625 Green 100 625 Green 100 625 Green 50 625 Green 200 514 Green 75 514 I would like to have a method to sort and add like this: Red 49 625 Red 10 125 Red 32 125 Green 350 625 Green 275 514 The actual sheet maybe hundreds of rows long with 30+ different items Thanks bunch and have a fun day! Marty -- Chevyone ------------------------------------------------------------------------ Chevyone's Profile: http://www.excelforum.com/member.php...o&userid=17953 View this thread: http://www.excelforum.com/showthread...hreadid=384847 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel - Grouping and Sorting Cells | Excel Worksheet Functions | |||
Microsoft Excel - Grouping and Sorting Cells | Excel Discussion (Misc queries) | |||
Adding a KeyID column for sorting | New Users to Excel | |||
sorting with macros | Excel Discussion (Misc queries) |