LinkBack URL
About LinkBacks
Looking for the very simplest formula there is to do this with as I'll have to apply indirect function to it. So, as an example, if my value is 10, I want to find the closest value to it in a column below, which would be 11:
20
15
18
11
8
7
Thanks!
How to find a value in a column that is closest to a given value
Looking for the very simplest formula there is to do this with as I'll have to apply indirect function to it. So, as an example, if my value is 10, I want to find the closest value to it in a column below, which would be 11:
20
15
18
11
8
7
Thanks!
Last edited by luv2glyd; 09-10-2014 at 01:20 PM.
You either quit or become really good at it. There are no other choices.
Something like this, maybe:
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Awesome! Thank you.
You're welcome & thanks!!
If this was your data:
20
15
18
11
9
7
What result would you expect? Both 9 and 11 are equally close.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Tony, (for my education), how would you deal with this? I'd add/subtract a very small number to split tied decisions... How would you deal with it?
It all depends on the OP's requirement/data.
They may want the closest that is less than the target value or the closest that is greater than the target value. Or, whichever closest appears first.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks