Results 1 to 3 of 3
  1. #1

    Sorting Blank Cells (Excel 2000)

    Stupid question, but is there anyway to sort a list with some blank cells. For example, I have one column with student names and the next col with grades. Let's say that each student in column A has several grades in column B. Do I have to enter every students name in column A multiple times next to each grade in column B if I want to sort the names alphabetically and have the grades stay with the appropriate names?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Dublin, Ireland, Republic of
    Thanked 0 Times in 0 Posts

    Re: Sorting Blank Cells (Excel 2000)

    I'm afraid that if you want to sort on Column A, you will have have a value in each row to be sorted. Instead of Using multiple rows (records) to store the grades, have you considered placing the grades in different columns (fields).

    You could have the Name in Column A, Grade No 1 in B, Grade No 2 in C, Grade No 3 in C etc. I do think that would be best approach unless you have some particular reason to do it the other way.

    Andrew C

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Redcliff, Alberta, Canada
    Thanked 5 Times in 5 Posts

    Re: Sorting Blank Cells (Excel 2000)

    The answer to your question lies in how you orient your data. See the attached sample which can be sorted regardless of whether their is data in the cell without mixing up your records.

    Attached Files Attached Files
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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