Category >
OTHERS
|| Published on :
Monday, May 17, 2021 || Views:
1270
||
Find Closest Value or Nearest Value in a Rangein EXCEL
Here Pawan Kumar will explain how to Find Closest Value or Nearest Value in a Range in EXCEL
=INDEX(B1:B7,MATCH(MIN(ABS(B1:B7-C1)),ABS(B1:B7-C1),0))
B1:B7 will be the range column
C1 Will be the number which you want to find in the range colum