Count number of times names appear in a column

I have a list of names all in one column, separated by row...

Example...

John Doe
John Doe
Jane Doe
Jane Doe
Jane Doe
James Jones
James Jones

I want to count how many times each name appears. Like this:

John Doe | 2
Jane Doe | 3
James Jones | 2

This is a very large list of names and I prefer not to have to
type each single name into a formula because there are hundreds
of separate names.

Thanks in advance for the help.

assuming your names are in column A then in column B use below formula

=countif($A$1:$A$1000,$A$1:$A$1000) and drag down

welcome to the forum, jeremysayshi. the easiest way is to do a Pivot Table. select the data, go to Insert -> PivotTable -> OK. put names in Row Labels & Names again in Values. if you don't want the Grand Total, right-click on it & Remove Grand Total.

if you want formulas, then try this array formula to get unique names in say G2 onwards:
=IFERROR(INDEX($A$2:$A$10,MATCH(0,COUNTIF(G$1:G1,$A$2:$A$10),0))&"","")

copy down as many cells as you need. then in H2, use a simple COUNTIF:
=COUNTIF(A:A,G2)

other way is to select all the name, copy and paste on a separate sheet go to remove duplicate by this way you will have all unique name then in column next to name. type formula as =countif(sheet1!$A$3:$A$1000,sheet2!A1) and drag down