Thread
:
minimum function
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ken Johnson
Posts: n/a
minimum function
Hi cutyfurby,
this array formula worked for me to return the minimum of A1:A10...
=MINA(IF(A1:A10=0,"",A1:A10))
after typing the formula you must commit it using Ctrl + Shift + Enter
Ken Johnson
Reply With Quote