Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Advanced Sorting

  1. #11
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    A precondition for my recommended approach is that you remove all repeating titles (i.e., Date..Time..Color..Freq). If you're unwilling to do that then perhaps someone can write a custom VBA for you.

  2. #12
    Guest

    Default

    I need to figure out how to sort the spects for a company
    There are thousands of records(thousands of headers) in a spect.
    So is writing VBA the only way to do the sorting with headers?
    Do you know how to write this kind of VBA by any chance?

  3. #13
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm sorry I only dabble in VBA.

  4. #14
    Guest

    Default

    I also tried to sort without the header but I still can't do the sorting.
    For example
    Before sorting:
    Date Time Color
    22....33...44
    ...........22
    ...........33
    11....22...44
    ...........55
    ...........66
    After sorting:
    Date Time Color
    11....22...22
    22....33...33
    ...........44
    ...........44
    ...........55
    ...........66
    I need to get a sorting like
    Date Time Color
    11....22...44
    ...........55
    ...........66
    22....33...44
    ...........22
    ...........33
    1. Select cells A1:B7 and choose the Edit | Go To... | Special... Blanks menu command.

    2. Without altering the selection Control+Enter the formula, =A2, into cell A3.

    2.5 Select columns A:B and perform Copy/Paste Special... Values.

    3. Select columns A:B and press [ Tab ] until cell A2 is the active cell.

    4. Choose the Format | Conditional Formatting ... menu command.

    5. Setup a "Formula Is" condition using the formula, =A1=A2, and format the Font color to match the cell background color (white, in my case).

    What does step 5 do? I can't see any changes after I finish that step.
    And What should I do after I finish those 5 steps?
    Should I select all the data and press sort button or should I just select the data under first 2 columns?


  5. #15
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    These results suggest that steps 1 thru 2.5 weren't performed properly. Step 5 preserves the appearance of your original data.

  6. #16
    Guest

    Default

    So what should I do after those 5 steps?
    Those 5 steps are just prepare me for soring right

  7. #17
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-01 12:20, Anonymous wrote:
    So what should I do after those 5 steps?
    Those 5 steps are just prepare me for soring right
    >So what should I do after those 5 steps?

    Do your sort on columns A and/or B.

    >Those 5 steps are just prepare me for soring right

    Yes.

  8. #18
    Guest

    Default

    I did those 5 steps over and over again and I still couldn't get my data to sort properly
    Anyways, thank you so much for helping Mark

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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