Finding a close match

[mailrail]

I have four time values in a row. The first value is a specific chosen time
value. The next three are demonstrated times. I need to find the closest
match of the three demonstrated times to the first column. Any help?

 

[Peo Sjoblom]

One way


=INDEX(B11,MATCH(MIN(IF(ABS(B11-A1)=MIN(ABS(B11-A1)),B11)),B11,0))


entered with ctrl + shift & enter

where B11 are the 4 values and A1 the chosen value



--


Regards,


Peo Sjoblom

 

[Peo Sjoblom]

Meant where B11 are the 3 demonstrated values


--


Regards,


Peo Sjoblom

 

[ShaneDevenshire]

Hi,

Here is another solution:

=INDEX(T,MATCH(MIN(ABS(T-A1)),ABS(T-A1),0))

I have named the range A2:A4, where your three demonstration times are, T.
You don't need to use the name, just substitute the address. A1 is the cell
containing the time you want to check.

This formula is an array, which means you must press Shift+Ctrl+Enter to
enter it.

Remember to format the cell to a time format.