+ Reply to Thread
Results 1 to 4 of 4

Sorting information by numerical values in multiple columns

  1. #1
    Registered User
    Join Date
    10-22-2014
    Location
    Europe
    MS-Off Ver
    2010
    Posts
    2

    Sorting information by numerical values in multiple columns

    I have a sheet full of raw information that will be converted into sales leads. It contains about 1600 rows with columns of information from A-AR

    I need to extract 500 rows of information based primarily on the data in two columns.

    Column A contains numbers ranging from 0-400'ish whereas Column B contains numbers ranging from about 300-3500.

    I want to neatly extract 500 rows of information where A is 2-400 and B is 2500-3500. This will need to be put in a separate excel sheet, leaving the remainding rows to be usable for someone else, who will extract the rest of them.

    I've used Excel now and then but never made much use of the more powerful features. However as I've taken on more responsibility at the office I think it's time to unlock the power that is Excel and I hope bothering you chaps with questions can do that for me.

    So far I've managed to format Column B into numbers and STILL not manage to sort it from highest to lowest (as for some damn reason it just sorts it based on the first digit).

    If you need more information or if my language is in any way unclear, please do let me know.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Sorting information by numerical values in multiple columns

    Welcome to the forum.

    You might profit from taking a few minutes to read the part of the forum rules headed Want to get your question answered quickly?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    10-22-2014
    Location
    Europe
    MS-Off Ver
    2010
    Posts
    2

    Re: Sorting information by numerical values in multiple columns

    Quote Originally Posted by shg View Post
    Welcome to the forum.

    You might profit from taking a few minutes to read the part of the forum rules headed Want to get your question answered quickly?
    General advice or is there something wrong with my post? I had a look at the rules but didn't see anything obviously off.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Sorting information by numerical values in multiple columns

    Specific to your post, in that those suggestions would make it easier for someone to help.

+ 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. [SOLVED] Excel 2007 Auto sorting rows by multiple columns that contain values that are calculated
    By bobatron83 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-27-2014, 01:32 PM
  2. [SOLVED] Re-arranging rows according to one columns numerical values
    By SteveyNZ in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-14-2012, 06:53 AM
  3. Sorting multiple columns with lookup values
    By eltharion in forum Excel General
    Replies: 13
    Last Post: 02-26-2012, 12:25 AM
  4. [SOLVED] Sorting Numerical Values...
    By Smohrman in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-07-2006, 03:00 AM
  5. [SOLVED] sorting two columns' information
    By Mark Hitchcock in forum Excel General
    Replies: 0
    Last Post: 07-11-2005, 04:05 PM

Bookmarks

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