| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Aligning similar rows
I am using Excel 2003.
I have a sheet showing the Item No., Brand, Description, sales, cost, stock of a branch. The sheet contains 2000 rows and 6 columns. I have similar sheets from 4 other branches, but the rows do not match. I am looking for a method to consolidate the data so that similar rows (i.e. rows starting with the same item no.) come in one row, so that I may add up the sales and stock figures of all branches for a given item no. Can someone help??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort (or group?) a spreadsheet by similar rows? | Excel Worksheet Functions | |||
| How can I delete similar rows in excel workbook with many sheets? | Excel Worksheet Functions | |||
| How do I compare similar rows of data in same worksheet | Excel Worksheet Functions | |||
| I want to delete duplicate rows of similar info and use the lates. | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
Threaded Mode
