+ Reply to Thread
Results 1 to 1 of 1

How to lookup and sort rows based on the values in cells

  1. #1
    Registered User
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2003
    Posts
    32

    How to lookup and sort rows based on the values in cells

    Hello,

    I have some values in a column, like 1000, 2000, 3000, 4000 and so on, in one excel.

    And i have another excel with some numbers, counts and comments.

    In that comments, numbers in the first excel will be mentioned somewhere in the whole statement.

    eg: this is a 2000 example

    Now i need to bring all the rows together which are all having 2000 in their comments and its the same for others too.

    The code i have got is

    Please Login or Register  to view this content.
    but it gives the value #N/A if the numbers are not available in 'Excel One'.

    If, in 'Excel one' i have only even numbers say 2000, 3000,.... but in the 'Excel two' i have few numbers like 2200, 3400,... so this numbers are in between 2000 to 3000 and it should also need to be found and sorted.

    Eg:
    2000
    2200
    3000
    3400

    is there a way to do this.

    Can anyone help me if it is possible to do.
    Attached Files Attached Files

+ 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] Sort and delete rows based on the values in a cell?
    By thup_98 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2013, 09:45 AM
  2. [SOLVED] Group/sort rows based on values in multiple columns?
    By teitoku in forum Excel General
    Replies: 5
    Last Post: 08-07-2012, 02:20 PM
  3. copy multiple rows and sort based on cell values
    By stevenwhite1968 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-18-2011, 03:12 AM
  4. Replies: 1
    Last Post: 01-24-2010, 04:35 PM
  5. Sort based on values of cells to the left
    By okriskao in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2009, 08:49 AM

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