I have a excel file (www.jonasson.se/nr.xlsx) with one column and 5000 rows. Each cell have a value between 1-9999. Many cells have the same value. How do I easily make Excel to tell me how many cell that have a certain number (I do not want to make a formula for every single value I want excel to count).
I simply want a list that tell me how many times value 2 value 2300 etc. is repeated.