Reducing Spreadsheet

  • Thread starter Thread starter motel112
  • Start date Start date
M

motel112

Hello,
I have a spreadsheet that has a lot of data. It has dollar amount in the
column A and and thier ssn in column B but some rows are duplicates but i
want to add the dollar amounts and delete the extra row to shorten the spread
sheet. please help
 
forgot to give you example.
A B
2799 123-45-6789
2344 123-45-6789
2312 123-45-2342
2344 123-45-2342
but thousands of lines like this and would like it to read.
A B
5143 123-45-6789
4656 123-45-2342
etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top