| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort does not preserve string of additions
6/4/06 sam <at sign isiusa.com
Sort does not preserve string of additions Ref rows 1-6 are original data Ref rows 1-6 copied and sorted by date (col B) Addition string is then incorrect ref ORIGINAL DATA 1 4-Jun $1.00 fuel 2 3-Jun $1.00 fuel 3 3-Jun $50.00 other 4 1-Jun $1.00 fuel 5 2-Jun $1.00 fuel 6 Total "fuel" by "+" function $4.00 ref SORTED DATA 4 1-Jun $1.00 fuel 5 2-Jun $1.00 fuel 2 3-Jun $1.00 fuel 3 3-Jun $50.00 other 1 4-Jun $1.00 fuel 6 Total "fuel" by "+" function $53.00 Office Excel 2003 (11.8012.6568) SP2 Part of Office Professional Edition --end |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
| Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
| Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
Threaded Mode
