closest value

  1. G

    VBA - finding a cell closest to a specific value

    Hello! I've written a code that finds the cell closest to 0 in a range, marks it and then uses it in calculations. However, my code works only if the cell closest to 0 is not the first cell. When the closest value is in the first cell, it doesn't mark the cell and the results of the...
  2. S

    Conditional Formatting - Highlight the closest value to a number

    Hello everyone! I need your help for the following example situation. I have a column of values, lets say from A1 to A5 (numbers with 3 digits after coma) and the cell B1 with the value 2.255: A1 - 0.856 A2 - 1.245 A3 - 1.455 A4 - 2.250 A5 - 2.260 I want to highlight the cell from A1 to A5...
  3. N

    Index Match/Vlookup has return column with no value, has to return closest number

    <tbody> 1395 - 6.90 30.14 1394 6.17 - 30.15 1393 - - 30.16 1392 - - 30.17 1391 - 6.91 30.18 1390 - - 30.19 1389 - - 30.20 1388 6.18 6.92 30.21 1387 - - 30.22 1386 - - 30.23 1385 - 6.93 30.24 1384 - - 30.25 1383 - - 30.26 1382 6.19 6.94 30.27 1381 - - 30.28 1380 - -...
  4. M

    How to find Value using 2 rows as a reference

    We're trying to find a pipe size in a row, that corresponds to a value of flow within a table (which is found by matching an input flow with a table), see example below. For example, a value for kvs and DN are input by user, the user then inputs desired flow rate which needs to match...
  5. S

    Return closest data item to average in Excel

    I have a list of data items in Excel and i want to find the item that is closest to the average (mean). e.g. If the list was 8 7 4 6 9 The average would be 6.8 so i would want the returned result to be 7. I'm drawing a complete blank. Thanks in advance.
  6. J

    Closest Number to Either 30%, 50% or 100%

    Hi! I Am trying to analyze some data. If a certain number is either 30%, 50% or 100% (exact match) then i'd chose it. (I already did this test). If instead is not exact, I would like to compare the numbers and chose the closest to either of those %. I would create several columns with complex...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top