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.
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 -----
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
