Forum Discussion
Which Formula/Rule to use to complete the following issue that I have:
If H115 Shows a value automatically entered from another TAB, I need L122 to choose a value in either H119 or H122 or H125 or H128 as they have different values based on the Values in G119,G122,G1...
How to find closest or nearest value (number or text string) in Excel?
Supposing you have a list of numbers in a column, and now you are required to find out the closest or nearest value to a given value from the list of numbers.
How do you deal with it?
Actually, you can find closest value or nearest value in Excel with following steps in the upper link.
Additional information:
Welcome to your Excel discussion space!
Hope I could help you with these information / links.
I know I don't know anything (Socrates)