Results 1 to 9 of 9

Thread: How can I sort thete numbers?

  1. #1

    How can I sort thete numbers?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I would like to be able to filter the attached numbers differently than what the numbers filter offers. I would like to be able to sort a group of numbers like in 3's or 4's. Is this possible? Not to complicate things it would be nice to be able to find an exact match. I have added a column F and notes under I and J. I have tried and tried several things but can not seem to find something that works. I appreciate any incite you may have





    Thanks
    Attached Files Attached Files

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    778
    Articles
    0
    Excel Version
    2010
    Hello and welcome to the forum. It might be me, but I can't understand what your wanting to do. The numbers you provide don't seem to be in any order, and the rows and columns you mention dont seem to fit your examples.
    Can you explain in a bit more detail, and show a more detailed example of how the data is arranged before and after you have processed it.

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    778
    Articles
    0
    Excel Version
    2010
    Just a further thought. If its possible to create a grid pattern of cells and place in it the arrangement of numbers you want to search for, it would be possible to search for this grid pattern in sets of columns of the same cell width.

    Is this anywhere close to what your trying to do ?

  4. #4

    Hope this example helps

    Quote Originally Posted by Hercules1946 View Post
    Just a further thought. If its possible to create a grid pattern of cells and place in it the arrangement of numbers you want to search for, it would be possible to search for this grid pattern in sets of columns of the same cell width.

    Is this anywhere close to what your trying to do ?
    That may do it but lease remember I am green (a newbie)


    This is exactly how it looks on my sheets:

    2
    6
    10
    8
    2
    2
    4
    12
    2
    8
    10
    4
    2
    2
    2
    2
    16
    2
    2
    6
    2
    I do have two other columns that have a location and number in series like 1,2,3,4,5,6,7,etc.... I want to be able to sort say all of the
    8
    10
    4 2
    throughout all my rows. I have 62,000 rows now but will have well over 300,000 rows of information by the time I am through. I am trying to save time and right now it is taking forever to locate the information. I hope this helps

  5. #5
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    719
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Definitely something missing as to what is actually wanted.

    People trying to help at http://www.mrexcel.com/forum/excel-q...fferently.html are also having difficulty following what is needed.

  6. #6
    Hmm. Okay? I have am excel sheet full of the above numbers in two columns In the example the 8 and 4 is in 1 column and the 10 and 2 in the other column. Some rows are blank. I want to be able to find all the say combinations as in the example. Only find the way it looks with those numbers i want to sort. In the above example lets say i want to search all the rows for ONLY the 6 and 8 in the right column or the 2,10 with the 6,8. It will look EXACTLY as in the examples

    Does this make better sense?

  7. #7
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    719
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Nope. Sorry, it still doesn't make sense to me.

    Any chance you are using the word "sort" instead of "filter"?

    At any rate hope someone will be able to offer assistance.

    Good luck.

  8. #8
    Hello,

    I am not able to provide assistance for this problem, but hopefully I can help the potential helpers (those smarter than me ). If my interpretation is right, he has a huge sequence of numbers and he is trying to find a specific combination within this sequence (perhaps something like trying to find a piece of a DNA strand..??). The problem I see first is that there are blanks all throughout the data. I assume these are important, but they do not appear to occur uniformly. I'm not sure that it is a "sort" or "filter" as much as it is a find. However, I can't think of a place to start with this one. Hope this helps someone.

    Best of luck,

  9. #9
    Yes you can call it a filter or mining. YES the blanks are very important as it represents a space in my logic. Im basically just trying to find the same group of numbers throughout my speadsheets. The numbers i will be looking for will he different everytime.

Posting Permissions

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