+ Reply to Thread
Results 1 to 5 of 5

How to find one of the closest values without a given value?

  1. #1
    Registered User
    Join Date
    09-30-2020
    Location
    KSA
    MS-Off Ver
    2016
    Posts
    3

    How to find one of the closest values without a given value?

    Hi everyone,
    I hope someone could help be in this, i searched google much with no way..
    If i have a table full of numbers, I want to find the most closest values, with return the one bigger. for example the table contains: 10,50,100,15,1000. the most closest numbers are: 10 and 15. The return will be: 15.
    Anyway? Thanks
    Last edited by skyangel14; 09-30-2020 at 07:08 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,488

    Re: How to find one of the closest values without a given value?

    Please read the yellow banner at the top of this page on how to attach a file.

  3. #3
    Registered User
    Join Date
    09-30-2020
    Location
    KSA
    MS-Off Ver
    2016
    Posts
    3

    Re: How to find one of the closest values without a given value?

    Is it most to upload a file? It is just a table of two columns of random numbers.. nothing else!!

  4. #4
    Forum Contributor
    Join Date
    01-25-2013
    Location
    near Philly, PA USA
    MS-Off Ver
    Excel 2019
    Posts
    145

    Re: How to find one of the closest values without a given value?

    When people ask for help, they usually don't tell the people who are helping how to help them.

  5. #5
    Registered User
    Join Date
    09-30-2020
    Location
    KSA
    MS-Off Ver
    2016
    Posts
    3

    Re: How to find one of the closest values without a given value?

    Thank you any way...
    My brother solve it perfectly..
    Instead of uploading the help requesting file, here is the answer file...
    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. Find Closest Value in a Table of Values
    By CT2243 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-27-2018, 04:40 PM
  2. [SOLVED] Find closest values and return adjacent values
    By John_B_Russell in forum Excel General
    Replies: 6
    Last Post: 03-28-2015, 01:33 AM
  3. Formula to find 3 closest values in a column when given one value
    By Brennen26 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-04-2014, 07:32 AM
  4. [SOLVED] Find closest values to a given value?
    By SneakyPiglet in forum Excel General
    Replies: 4
    Last Post: 04-23-2013, 08:49 AM
  5. How to find closest values in multiple columns and return adjacent values.
    By Patrician in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-28-2013, 01:47 PM
  6. Replies: 1
    Last Post: 11-02-2012, 08:32 AM
  7. Find two closest values that are higher
    By calebm12 in forum Excel General
    Replies: 11
    Last Post: 06-30-2009, 10:28 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