Minimum is ruining my day

[PattyinNO]

I'm not experienced at all in Excel but trying to find smallest number located in designated cells (CELLS NOT IN A RANGE) excluding zeros. Don't know how to do an array formual. iS THERE a Simple way to do this?

[NBVC]

Is there a pattern to the non-contiguous cells?

Is there anything between the cells?

[EdMac]

Hi

=IF(MIN(B1:B6)=0,SMALL(B1:B6,2),MIN(B1:B6))

will work if cells are contiguous - can you arrange your data so that it is?

Ed

[mrice]

How about

=MIN($A$1,$B$2,$C$3,$D$4)

?

[PattyinNO]

Thanks. Data was in noncontiguous cells...I tried and this seemed to help get me closer
=SMALL((A1,C1,E1),1+frequency((A1,C1,E1),0))

I get an error message when cells are empty but I'm much happier now. get some kinda NUM! error when everything empty.

[NBVC]

You can try:

=MIN(IF(ISNUMBER(A1:E1),IF((MOD(COLUMN(A1:E1)-COLUMN(A1),2)=0)*(A1:E1),A1:E1)))

confirmed with CTRL+SHIFT+ENTER not just ENTER

Gives you 0 if you have all blanks.