I have a list (a column of cells, say) of numbers. These will be recalculated continuously as part of an optimization routine.
I need to generate another column that lists the number of different duplicates in the original list. (e.g. this is what the Tally command does in Mathematica.)
For example:
21 7 3 7 7 3 => 3 2 1
21 7 3 7 21 2 => 2 2 1 1
21 7 3 2 1 0 => 1 1 1 1 1 1
Because of the recalculations this has to be by formula, not code.
Bookmarks