Hello Azam,

Use this Array formulas.

=MIN(IF(ISNUMBER(1/$B$2:$B$100),$A$2:$A$100))

=MAX(IF(ISNUMBER(1/$B$2:$B$100),$A$2:$A$100))