Divide by the minimum non-zero number in a range of cells

[Shane Devenshire]

Hi,

Althought this turned out to be a very interested thread for all of us, I
recommend that in the future you post the actual question you are trying to
solve. Your solution of using a hidden column/ an extra column of course is
not necessary. You can modify the single cell solutions we have developed
for your problem to work for your real problem. Now you are doing a max if.

 

[JoeU2004]

Or after some thought how about just
=SUMPRODUCT(MIN(2*(A1:A8=0)+A1:A8))

Perhaps you should do less "thought" and more testing. Try A1:A8 equal to
{0,3,3,3,3,3,3,0}. Klunk!

Anyway, I think the horse is dead.


----- original message -----