Is there a query or something similar i could do to count how many of one number i have in my columns. For example

Column 1 Product ID

1
2
2
1
3
3
1
2
2
2
3
3


Etc where it will count how many 3's and how many 2's how any 1's etc

how would i go about this?

Use a select query and group by Product ID use the Sigma icon on the task bar (Σ) Then in the next column enter Cnt:1 and change the group by to Count.

David

Thanks it worked :)