Gazzat
New Member
- Joined
- Dec 5, 2021
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi (question below screenshot) ,
Large spreadsheet with some replicate values in column A. I am wanting to count how many replicates in column A and then establish a count of cells with each replicate value, so I can order them eg. I would like to know how many cells in column A contain C7532, how many cells in column A contain W4254.............etc- but without having to specify each value in the county formula.
I feel like I'm missing something obvious, but have been going in circles for a while so some help would be greatly appreciated
Thanks!
Gaz
Large spreadsheet with some replicate values in column A. I am wanting to count how many replicates in column A and then establish a count of cells with each replicate value, so I can order them eg. I would like to know how many cells in column A contain C7532, how many cells in column A contain W4254.............etc- but without having to specify each value in the county formula.
I feel like I'm missing something obvious, but have been going in circles for a while so some help would be greatly appreciated
Thanks!
Gaz