find smallest number closest to an integer in an array excel

Question

I have a dynamic list of values in an excel worksheet. I need to find a way to identify the lowest number in the array that is closest to a whole number. example: in one instance the list includes the following numbers: 1.56, 1.65, 1.71, 1.84, 1.94, 2.00, 2.06, 2.03, 2.22........2.95, 3.05, 3.81, 4.00 etc. the number I want to find in this instance is 2.00. Is there a function in Excel that I can use for this?

Answer 1

Just a thought:

Formula for dif:

=ABS(IFERROR(MID($A2,1,FIND(".",$A2,1)-1),$A2)-$A2)

Formula for Min:

=INDEX($A$2:$B$14,MATCH(MIN($B$2:$B$14),$B$2:$B$14,0),1)

Results: