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

  • Thread starter Thread starter Opus
  • Start date Start date
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.
 
Shane Devenshire said:
Or after some thought how about just
=SUMPRODUCT(MIN(2*(A1:A8=0)+A1:A8))
Click to expand...

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 -----
 
Back
Top