how to display only unique values

Originally Posted by zbor

zazzz, look at here.

You must have 0 in D31.
Also, in E32 is UDF function so if you copy to your workbook you must also copy code (not only function).

Thanks man.

2 questions - what's the significance of E31, where there's a red highlighted 0?
When you say copy code not only function, what exactly does that mean, that copying the formula wont be enough and that this is macro related? Not sure if that's what you're saying but if it is, why would that be - the formula should work all the time, no?

On another note I've seen people saying something about putting in a formula by hitting control-shift-enter, how does that work? Do you do it at time of pasting, or after when trying to run, smth else?