| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort and put a space between each sorted choice
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I sort and put a space between each sorted choice
"Stewart" wrote
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 Sort the table by the ssn col first, then apply Data SubTotals using "Sum" for the col with the numbers -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
