Sorting
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Sorting

  1. #1
    Guest

    Default

     
    Hello people
    I have a spreadsheet which has the following format

    Color Weight Code otherdata
    33 44 55 A
    B
    C
    Color Weight Code otherdata
    22 33 44 D
    E
    F
    I am trying to sort the "otherdata" catagory by either Color, Weight or Code.
    I think the excel's function can't do this kind of sort and I am thinking about creating a userform with drop down box for letting users to choose which column they want to sort by.
    However, I am not sure how to start(eg. how do you attach "otherdata" catagory with its specific Color Weight and Code then sort)???
    Please help me out

    Thank you in advance

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Your data is not Excel-friendly. I doubt you could possibly find a way to do this.
    ~Anne Troy

  3. #3
    Guest

    Default

    Oh no, even the macro can't do it?

  4. #4
    Guest

    Default

    Could someone please help me
    Is this kind of sorting can be done in any way?

  5. #5
    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-07 07:25, Anonymous wrote:
    Could someone please help me
    Is this kind of sorting can be done in any way?
    Eliminate your redundant headers and your problem is solved. If necessary you can add them back afterwards.

    [ This Message was edited by: Mark W. on 2002-03-07 08:34 ]

  6. #6
    Guest

    Default

    if I have many headers like
    data1 data2 data3
    11 33 33


    data1 data2 data3
    11 33 44
    is there an easy way to delete those headers at once?

  7. #7
    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-07 08:36, Anonymous wrote:
    if I have many headers like
    data1 data2 data3
    11 33 33


    data1 data2 data3
    11 33 44
    is there an easy way to delete those headers at once?
    Yeah, an easy way to delete, but not one to reinstate them after the sort. All you need to do to identify your headers is...

    =ISTEXT(cell)

    ...where "cell" is a cell reference to the cell in the 1st column. If this formula returns TRUE that row is a header.

  8. #8
    Guest

    Default

    Right now, I have many headers in the format:

    Data1 Data2 DAta3
    11 22 33


    Data1 Data2 Data3
    22 33 44
    ...
    ...
    I tried =istext(Data1) on both headers, and they all return True
    So, how can I delete the headers after the first one?
    Thanks

  9. #9
    Guest

    Default

      
    Hi Mark
    After I did the number fill in and change the duplicated number to white colour, and press sort button. Some of the numbers, although the numbers are correct, they appear white where they should not be
    why is it doing that?
    Thanks

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
  •  

 

 
DMCA.com