I have got a challenge from a colleague:

He has a spreadsheet he uses for collection component errors. Each time he
has an error, the number of the component i registered. The numbers are in
the A-column. Now he wants to know how many components has beeen registerede
once (on error), twice (two errors) and so on up to the largest number of
registered errors. He does'nt care about which component it is. He only
wants the number.

Imange this list
A1
A2
A1
A4
A1
A6
A3
A4
A2
A8

The resoldt be somethin like:

One registration 3 components (A8, A3 and A6)
Two registrations 2 components (A2 and A4)
Three Registrations 1 component (A1)

and so on.


PIVOT is not an option. Neither is anything that demands a manuel
manipulation of the spreadsheet before the caluclation is done, so it has to
be done by a formula. I have considered SUBTOTAL og FREQUENCY, but neither
of them does the trick.

Any suggestions

Jan