Results 1 to 5 of 5

Force descending sort to Start with Numbers

Threaded View

The Smuffer Force descending sort to... 09-04-2006, 03:12 PM
raypayette Replace N/A with a slash / ... 09-04-2006, 03:44 PM
The Smuffer Doesn't seem to matter 09-04-2006, 03:58 PM
raypayette You're quite right! I hadn't... 09-04-2006, 04:07 PM
The Smuffer Not quite what I need 09-04-2006, 04:24 PM
  1. #1
    Registered User
    Join Date
    03-03-2006
    Posts
    7

    Force descending sort to Start with Numbers

    Here is an example of my spreadsheet:

    Player GP G A PTS PT/G SH P P PMS

    Spare _ _ _ _ _ _ _ _ _
    Spare _ _ _ _ _ _ _ _ _
    Spare _ _ _ _ _ _ _ _ _
    Ray 4 2 2 4 1.00 0 0 0
    Steve 5 2 2 4 0.80 0 0 0
    Dave 3 3 0 3 1.00 0 0 0
    Brian 2 1 1 2 1.00 0 0 0
    Denis 1 1 0 1 1.00 0 0 0
    Al 0 0 0 0 0.00 0 0 0



    I have a macro to sort Points(PTS) descending, Points/game(PT/G) descending, then Goals(G) descending.

    The cells in this sheet are links to a master records sheet. Spare Players have values of N/A.

    Problem is when Excel Sorts Descending it puts the N/A's First then the numbers.

    How can I get the Spare(N/A) values to be listed last and still have my numbers descending?
    Last edited by The Smuffer; 09-04-2006 at 03:35 PM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1