• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula Challenge 017 – Conditional Unique Nth Value

Sajan, you don't even need that FALSE in there:


38 characters. sas.

(short and sweet).
You also don't need the inner IF


Chops 2 characters off, taking us down to 36.
Hi Luke ,

Not necessarily ; boundary condition testing is an important aspect of coding ; it is just that in the race for the shortest formula , we are giving the go-by to everything else !

In fact , every challenge should first spell out all the possible boundary conditions , so that the formulae which are suggested are robust enough ; if not , let us clearly specify the conditions which need not be met !

Not neccessarily Frequency's fault. These all work correctly, don't they?









= {0;0;0;0;0;0;12

Note that 12 gets placed at the position of the minimum number in the bins_array
Nice post on the breakdown, Jeff. I admit, these 2 challenges have been helpful for me in that I've had to learn more about FREQUENCY, and how it works. Now if I can get a better idea on MMULT...

Isn't that what FREQUENCY is designed for? I mean,





return the same result. Excel places them in "bins" per element size in data irrespective of the sort order.

Edit: In fact, I sometimes suspect that the extra element that FREQUENCY has [bins_array_size + 1], comes from some kind of comparison algorithm in the background for size sort.