| Home |
| Search |
| Today's Posts |
|
#8
|
|||
|
|||
Make sure you are not selecting the total row. Make new
worksheet so you do not destroy you existing data. Put Numbers in A1-A5, put a total in A6. Select A1-A5 and sort. Did A6 change? -----Original Message----- I have a spreadsheet with about 20 columns and 8,000 rows. I have numerical data in most of the columns corresponding to people. Like this: John 9 6 Debbie 9 5 James 8 5 Total 26 16 If I highlight all columns and do a sort by the person's name, the total number at the bottom changes even if the data has not changed. Do you know why this is happening? Thanks in advance for any help! . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I sort email address, dedupes,check for errors in a docume. | Excel Discussion (Misc queries) | |||
| "-" ignored in sort | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
Threaded Mode
