Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Finding values closest to a certain number then returning th

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have 3 columns of data. I want Excel to find the value that is closest to a specified value then display that row in another sheet. For example I want to find the value closest to 65 and I have 64.8 and 65.4, i want excel to pick the row with 64.8 and then put that row of data in another table I specify. I'm looking for VBA code for the most part. Thanks to all!!!

    -Lars

    [ This Message was edited by: lars92RS on 2002-02-28 09:06 ]

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ttt

Some videos you may like

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
  •