+ Reply to Thread
Results 1 to 3 of 3

Rows inserted into a List will not sort properly

  1. #1
    Derek Jones
    Guest

    Rows inserted into a List will not sort properly

    I have a spreadsheet that is sorted first by department, then by number. The
    departments are sorting OK, but within some of the departments, the numbers
    are not being sorted properly. This is happening in departments where some
    rows have been inserted into the spreadsheet and data has been entered. In
    those departments, after running the sort, the numbers of the inserted rows
    appear first, followed by the remaining numbers. I've tried reformatting the
    cells and Iv'e also tried copying the sheet and pasting it into a new file,
    both to no avail. Any ideas?

    Excel 2003, Windows XP, all SPs applied.

    Derek Jones
    Software Support Specialist
    Shenandoah University
    Winchester, VA

  2. #2
    Dave Peterson
    Guest

    Re: Rows inserted into a List will not sort properly

    If that field of numbers is actually a combination of some numbers and some text
    (that looks like numbers), then that could be a problem.

    You could try converting the text numbers to number numbers.

    Select an empty cell
    copy it
    select your range of numbers
    edit|Paste special|check add.

    (changing the format of the cell isn't enough to change the value.)

    Derek Jones wrote:
    >
    > I have a spreadsheet that is sorted first by department, then by number. The
    > departments are sorting OK, but within some of the departments, the numbers
    > are not being sorted properly. This is happening in departments where some
    > rows have been inserted into the spreadsheet and data has been entered. In
    > those departments, after running the sort, the numbers of the inserted rows
    > appear first, followed by the remaining numbers. I've tried reformatting the
    > cells and Iv'e also tried copying the sheet and pasting it into a new file,
    > both to no avail. Any ideas?
    >
    > Excel 2003, Windows XP, all SPs applied.
    >
    > Derek Jones
    > Software Support Specialist
    > Shenandoah University
    > Winchester, VA


    --

    Dave Peterson

  3. #3
    Derek Jones
    Guest

    Re: Rows inserted into a List will not sort properly

    That didn't work, but I found something that did. For each department, I
    copied the first instance of a specific value and did a paste special
    (values) in all the other cells that held the same value. After doing that,
    the sort worked fine. Thanks.

    Derek

    "Dave Peterson" wrote:

    > If that field of numbers is actually a combination of some numbers and some text
    > (that looks like numbers), then that could be a problem.
    >
    > You could try converting the text numbers to number numbers.
    >
    > Select an empty cell
    > copy it
    > select your range of numbers
    > edit|Paste special|check add.
    >
    > (changing the format of the cell isn't enough to change the value.)
    >
    > Derek Jones wrote:
    > >
    > > I have a spreadsheet that is sorted first by department, then by number. The
    > > departments are sorting OK, but within some of the departments, the numbers
    > > are not being sorted properly. This is happening in departments where some
    > > rows have been inserted into the spreadsheet and data has been entered. In
    > > those departments, after running the sort, the numbers of the inserted rows
    > > appear first, followed by the remaining numbers. I've tried reformatting the
    > > cells and Iv'e also tried copying the sheet and pasting it into a new file,
    > > both to no avail. Any ideas?
    > >
    > > Excel 2003, Windows XP, all SPs applied.
    > >
    > > Derek Jones
    > > Software Support Specialist
    > > Shenandoah University
    > > Winchester, VA

    >
    > --
    >
    > Dave Peterson
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.05645 seconds
  • Memory Usage 8,868KB
  • Queries Executed 16 (?)
More Information
Template Usage (30):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (3)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (3)postbit_legacy
  • (3)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (40):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php
  • ./includes/functions_prefix.php 

Hooks Called (44):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1