How do I sort and put a space between each sorted choice

G

Guest

I have a spreadsheet that list the same ssn several times but with different
numbers in another column. I need to sort by A and B and input a space after
both a and b match but the whole set not each match. Then those need to sum
 
M

Max

I have a spreadsheet that list the same ssn several times
but with different numbers in another column.
I need to sort by A and B and input a space after
both a and b match but the whole set not each match.
Then those need to sum
Click to expand...

Sort the table by the ssn col first,
then apply Data > SubTotals
using "Sum" for the col with the numbers
 

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

Similar Threads

How do I sum here using criteria there? 10
moving row data to a colunm in sorted order 9
Excel data sort 1
How do I paste in sorted area? 4
Data Sort 5
dynamically sorted list with duplicates 5
How can I find out if numbers in one column are also in a secondcolumn please? 9
characters which are matching between Data 1 & Data 2 12

Top