Hello,

I have created a table, each cell in the table contains a number. Some cells in the table have a number the same as another cell, some cells have a number the same as ten other cells, some cells have a number which is unique.

I want to create a new table, which lists each unique number in one column, and in the second column, the amount of instances (repetitions) of that number.

for example if the table is : 7 4 7 2 7

the resulting new table will show:

7 3 (the number 7 occurs 3 times)

4 1 (the number 4 occurs 1 time)

2 1 (the number 2 occurs 1 time)

How can I perform this count ish type of function using a textDAT or tableDAT.

Any assistance is appreciated,

Anthony.