Don't use Google Sheets often, need a bit of help.

[DarkBlade2117]

So I have about 5900 rows of data and was wondering how I could find out how much of each number has come up in the row. So for example.

Column A

1 [   5   ]

2 [   5   ]

3 [   4   ]

5 [   19 ]

 

I want to be able to find out there are 2 5's, 1 4 and 1 19 though this is with 5900 rows and about 20 different numbers.

[g12601]

2 minutes ago, DarkBlade2117 said:

So I have about 5900 rows of data and was wondering how I could find out how much of each number has come up in the row. So for example.

Column A

1 [   5   ]

2 [   5   ]

3 [   4   ]

5 [   19 ]

 

I want to be able to find out there are 2 5's, 1 4 and 1 19 though this is with 5900 rows and about 20 different numbers.

I think it is 

"=Mode"

then highlight the section

https://www.thoughtco.com/google-spreadsheets-mode-function-3123874

 

[exercutor5]

https://support.google.com/docs/answer/3093480?hl=en

 

=COUNTIF(A1:A5, "=5")

 

Try this.