Results 11 to 20 of 22

Thread: Looking for Value in Another Column, Evaluating and Then Looking in Another Column

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Feb 2013
    Posts
    26
    Rep Power
    0

    Looking for Value in Another Column, Evaluating and Then Looking in Another Column

    I have a value say in Cell A1.

    I want to compare the value in Cell A1 with all the values in the cells in Column B (which may have thousands).

    I am interested in all the values in Column B which are lower than the value in cell A1.

    If a cell value in Column B is lower than the value in A1, then I want to go to the adjacent column, Column C, and see the value of that cell, the one adjacent to the one in Column B.

    Now I want to compare the values in Column C and pick the 10 or 15 highest and be put in cells A2, A3, A4, etc..

    Can this be done?

    (This is my first post here. I followed Rick Rothstein here.)
    Last edited by olives; 02-15-2013 at 12:08 AM.

Similar Threads

  1. Replies: 10
    Last Post: 05-23-2013, 12:30 PM
  2. Converting a Column Number to a Column Letter
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 6
    Last Post: 12-17-2012, 02:29 AM
  3. Column to Row and Row to Column
    By lokvan in forum Excel Help
    Replies: 1
    Last Post: 11-30-2012, 09:30 AM
  4. Replies: 1
    Last Post: 08-07-2012, 11:04 PM
  5. Replies: 3
    Last Post: 08-05-2012, 09:16 PM

Posting Permissions

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