Excel Unique with REDUCE and Vstack

You will see from the alignment of the 1 in G4 that it's text, not a number, so in that range, it and the number 1 are unique items.

Try this:

Please Login or Register  to view this content.

You could also use this to the same effect:

Please Login or Register  to view this content.

When appropriate, I like to make use of the opening criterion in REDUCE to add a header row:

Please Login or Register  to view this content.

Ok, lets see if I understand, so by using "", the first value becomes part of y variable and is operated upon by the double unary
which it isn't if the initial value is empty?

// added after the above ; Initial value empty but make x a number; UNIQUE( VSTACK( --x, count)) ))))

Thanks for the other suggestions.

Richard .

Glad to have helped.