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))
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))
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks