hi excelers, I will try to make this question clear:
how does one find the lowest or highest numbers from other numbers i.e.
(highest num) "25"
(lowest num) "5"
which number 6 or 20 match closest to the two numbers above!
should result in = "6" as its the closet by digits to lowest num 5.
but 20 is not chosen as its 5 digits away from 25.
hope this is clear
Bookmarks