ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   counting values in a column (https://www.excelbanter.com/excel-programming/439612-counting-values-column.html)

Jerry

counting values in a column
 
I have a column with values ranging from 1 to 85. I need to count
occurrences of the values and put them in another spreadsheet. For instance
column c has the values 1,4,25,2,35,65,1,35,70,25,25 and I want to put in the
other spreadsheet the values as Column A Column B
1 2
2 1
4 1
25 3
35 2
65 1
70 1
Your assistance is greatly appreciated.


All times are GMT +1. The time now is 01:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com