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...

Some videos you may like

This Week's Hot Topics

Top