+ Reply to Thread
Results 1 to 2 of 2

Trying to sort a file without using the blanks

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Trying to sort a file without using the blanks

    I have 2 rows that I want the first column to be the same. I have a rule to add a Z to the name for sorting purposes that works well, and if the even line is blank the odd line is also blank, however when I do a sort of the sheet, it puts the blank cells in the top of the list it adds the Z to the column name for about 6 or 8 lines. They look like Row 2 "NameZ" Row 3 "NameZZ" Row 4 "NameZZZ" for about 8 rows. I am trying to sort the list alpha so that we can easily find a name. The next thing I will want to do is sort the data as it is updated if that is at all possible.

    The table is kind of like this

    Name Date/Offense Date/Offense Date/Offense

    Joe 01/01/10 02/01/10

    JoeZ Parking Speeding

    Mary 04/01/10 06/10/14

    MaryZ Speeding Speeding

    So I want to keep the name order intact, and associated with the correct lines of the report associated with the correct person. So that after sorting Mary still has speeding offenses associated with her. I am doing what I can to learn this so anything to help is great. I am really trying to figure out the VB end of these things, but the easiest/best way to get to the end works for me.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013

    Re: Trying to sort a file without using the blanks

    I would repeat the name in column A and your problem is solved. Alternatively you could create columns between the Date/Offense to make a column for DATE separately and OFFENSE separately.

    Stacking like that is not standardized and makes managing the data annoying.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 04-16-2015, 06:29 PM
  2. Sort order with Blanks
    By DanBlum in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-23-2011, 12:02 PM
  3. Sort With Blanks
    By DaFonz01 in forum Excel General
    Replies: 2
    Last Post: 04-01-2010, 10:36 AM
  4. How NOT to Sort Blanks that aren't Blanks
    By Tirren in forum Excel General
    Replies: 1
    Last Post: 08-17-2009, 01:45 PM
    By Terry Millican in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-25-2006, 09:45 PM
  6. Replies: 5
    Last Post: 10-14-2005, 06:05 PM
  7. Sort a row of strings, some containing blanks
    By KobusD in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-02-2005, 04:05 PM

Tags for this Thread


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