Hello All,
First time poster. I have a large Excel Spreadsheet that has 32 columns and over 50,000 lines of data. Column U has a 4 digit code. There are over 100 different codes in column U. I want Excel to create a new worksheet where each code is only listed once but the contents are summated. Might be easier to show an example.
Here is how the data appears now:
Column U Column X
AAAA $10
AAAA $20
AAAA $50
AAAA $10
AAAA $100
BBBB $20
BBBB $10
BBBB $50
CCCC $80
CCCC $90
Here is the format I want excel to create:
AAAA $190
BBBB $80
CCCC $170
Thanks, Bill
Bookmarks