Formula needed to count from a blank sheet & to match how many times they are used

[Steviefiege]

Hi,
I have a list of names below:

[TABLE="width: 130"]
<colgroup><col></colgroup><tbody>[TR]
[TD]M.P.Tregoning[/TD]
[/TR]
[TR]
[TD]S.C.Williams[/TD]
[/TR]
[TR]
[TD]W.P.Mullins[/TD]
[/TR]
[TR]
[TD]B.M.R.Haslam[/TD]
[/TR]
[TR]
[TD]T.D.Easterby[/TD]
[/TR]
[TR]
[TD]M.J.Attwater[/TD]
[/TR]
[TR]
[TD]Mr M.T.Walford[/TD]
[/TR]
[TR]
[TD]Mrs Dianne Sayer[/TD]
[/TR]
[TR]
[TD]A.W.Carroll[/TD]
[/TR]
[TR]
[TD]R.A.Fahey[/TD]
[/TR]
[TR]
[TD]Mrs A.J.Perrett[/TD]
[/TR]
[TR]
[TD]M.Johnston[/TD]
[/TR]
[TR]
[TD]J.Butler[/TD]
[/TR]
[TR]
[TD]M.W.Easterby[/TD]
[/TR]
[TR]
[TD]R.A.Fahey[/TD]
[/TR]
[TR]
[TD]D.R.C.Elsworth[/TD]
[/TR]
[TR]
[TD]Ed Walker[/TD]
[/TR]
[TR]
[TD]R.Hannon[/TD]
[/TR]
[TR]
[TD]Sir Michael Stoute[/TD]
[/TR]
[TR]
[TD]M.R.Channon[/TD]
[/TR]
[TR]
[TD]J.H.M.Gosden[/TD]
[/TR]
[TR]
[TD]Sir Michael Stoute[/TD]
[/TR]
[TR]
[TD]S.C.Williams[/TD]
[/TR]
[TR]
[TD]J.Ryan[/TD]
[/TR]
[TR]
[TD]M.L.W.Bell[/TD]
[/TR]
[TR]
[TD]C.Appleby[/TD]
[/TR]
[TR]
[TD]J.H.M.Gosden[/TD]
[/TR]
[TR]
[TD]N.Tinkler[/TD]
[/TR]
[TR]
[TD]A.King[/TD]
[/TR]
[TR]
[TD]M.Johnston[/TD]
[/TR]
[TR]
[TD]K.R.Burke[/TD]
[/TR]
[TR]
[TD]Ben Pauling[/TD]
[/TR]
[TR]
[TD]P.J.Hobbs[/TD]
[/TR]
[TR]
[TD]Tim Vaughan[/TD]
[/TR]
[TR]
[TD]N.J.Henderson[/TD]
[/TR]
[TR]
[TD]C.L.Tizzard[/TD]
[/TR]
[TR]
[TD]N.J.Henderson[/TD]
[/TR]
[TR]
[TD]Owen Burrows[/TD]
[/TR]
[TR]
[TD]R.A.Fahey[/TD]
[/TR]
[TR]
[TD]J.H.M.Gosden[/TD]
[/TR]
[TR]
[TD]Sir Michael Stoute[/TD]
[/TR]
[TR]
[TD]R.M.H.Cowell[/TD]
[/TR]
[TR]
[TD]A.Bailey[/TD]
[/TR]
[TR]
[TD]A.Bailey[/TD]
[/TR]
[TR]
[TD]C.G.Cox[/TD]
[/TR]
[TR]
[TD]C.Hills[/TD]
[/TR]
[TR]
[TD]M.P.Tregoning[/TD]
[/TR]
[TR]
[TD]Paul George[/TD]
[/TR]
[TR]
[TD]Mrs Dunn[/TD]
[/TR]
[TR]
[TD]R.Hannon[/TD]
[/TR]
[TR]
[TD]Miss Gay Kelleway[/TD]
[/TR]
[TR]
[TD]M.Madgwick[/TD]
[/TR]
[TR]
[TD]W.J.Haggis[/TD]
[/TR]
[TR]
[TD]K.R.Burke[/TD]
[/TR]
[TR]
[TD]George Baker[/TD]
[/TR]
[TR]
[TD]Amy Murphy[/TD]
[/TR]
[TR]
[TD]W.G.M.Turner[/TD]
[/TR]
[TR]
[TD]M.Johnston[/TD]
[/TR]
[TR]
[TD]Adam West[/TD]
[/TR]
[TR]
[TD]Mr M.T.Walford[/TD]
[/TR]
[TR]
[TD]Miss J.A.Camacho[/TD]
[/TR]
[TR]
[TD]P.T.Midgley[/TD]
[/TR]
[TR]
[TD]M.Dods[/TD]
[/TR]
[TR]
[TD]Adam West[/TD]
[/TR]
[TR]
[TD]P.J.Hobbs[/TD]
[/TR]
[TR]
[TD]Padraig Roche[/TD]
[/TR]
[TR]
[TD]Emmet Mullins[/TD]
[/TR]
[TR]
[TD]Peter Fahey[/TD]
[/TR]
[TR]
[TD]D.K.Weld[/TD]
[/TR]
[TR]
[TD]H.de Bromhead[/TD]
[/TR]
[TR]
[TD]W.P.Mullins[/TD]
[/TR]
[TR]
[TD]W.P.Mullins[/TD]
[/TR]
[TR]
[TD]W.P.Mullins[/TD]
[/TR]
[TR]
[TD]G.Elliott[/TD]
[/TR]
[TR]
[TD]W.P.Mullins[/TD]
[/TR]
[TR]
[TD]N.Meade[/TD]
[/TR]
[TR]
[TD]N.J.Henderson[/TD]
[/TR]
[TR]
[TD]C.L.Tizzard[/TD]
[/TR]
[TR]
[TD]Peter Fahey[/TD]
[/TR]
[TR]
[TD]S.Dixon[/TD]
[/TR]
[TR]
[TD]D.Carroll[/TD]
[/TR]
[TR]
[TD]J.M.P.Eustace[/TD]
[/TR]
[TR]
[TD]P.D.Evans[/TD]
[/TR]
[TR]
[TD]Robyn Brisland[/TD]
[/TR]
[TR]
[TD]Archie Watson[/TD]
[/TR]
[TR]
[TD]M.Murphy[/TD]
[/TR]
[TR]
[TD]Archie Watson[/TD]
[/TR]
[TR]
[TD]R.Charlton[/TD]
[/TR]
[TR]
[TD]J.Tate[/TD]
[/TR]
[TR]
[TD]K.Dalgleish[/TD]
[/TR]
[TR]
[TD]B.Ellison[/TD]
[/TR]
[TR]
[TD]P.T.Midgley[/TD]
[/TR]
[TR]
[TD]K.Dalgleish[/TD]
[/TR]
[TR]
[TD]Rebecca Bastiman[/TD]
[/TR]
[TR]
[TD]R.A.Fahey[/TD]
[/TR]
[TR]
[TD]Mrs J.Harrington[/TD]
[/TR]
[TR]
[TD]B.I.Case[/TD]
[/TR]
[TR]
[TD]P.Maher[/TD]
[/TR]
[TR]
[TD]Harry Fry[/TD]
[/TR]
[TR]
[TD]W.P.Mullins[/TD]
[/TR]
[TR]
[TD]W.P.Mullins[/TD]
[/TR]
[TR]
[TD]E.P.Harty[/TD]
[/TR]
[TR]
[TD]W.P.Mullins[/TD]
[/TR]
[TR]
[TD]W.P.Mullins[/TD]
[/TR]
[TR]
[TD]N.Meade[/TD]
[/TR]
[TR]
[TD]Archie Watson[/TD]
[/TR]
[TR]
[TD]B.Smart[/TD]
[/TR]
[TR]
[TD]R.A.Fahey[/TD]
[/TR]
[TR]
[TD]W.J.Haggis[/TD]
[/TR]
[TR]
[TD]Archie Watson[/TD]
[/TR]
[TR]
[TD]R.A.Fahey[/TD]
[/TR]
[TR]
[TD]M.Dods[/TD]
[/TR]
[TR]
[TD]R.G.Fell[/TD]
[/TR]
[TR]
[TD]C.G.Cox[/TD]
[/TR]
[TR]
[TD]J.L.Flint[/TD]
[/TR]
[TR]
[TD]Ed Walker[/TD]
[/TR]
[TR]
[TD]H.Candy[/TD]
[/TR]
[TR]
[TD]Eve Johnson Houghton[/TD]
[/TR]
[TR]
[TD]M.Madgwick[/TD]
[/TR]
[TR]
[TD]A.King[/TD]
[/TR]
[TR]
[TD]J.W.Mullins[/TD]
[/TR]
[TR]
[TD]Robyn Brisland[/TD]
[/TR]
[TR]
[TD]Kevin Frost[/TD]
[/TR]
[TR]
[TD]C.Hills[/TD]
[/TR]
[TR]
[TD]J.A.Osborne[/TD]
[/TR]
[TR]
[TD]S.France[/TD]
[/TR]
[TR]
[TD]S.Dixon[/TD]
[/TR]
[TR]
[TD]P.J.Hobbs[/TD]
[/TR]
[TR]
[TD]T.R.George[/TD]
[/TR]
[TR]
[TD]R.Hannon[/TD]
[/TR]
[TR]
[TD]M.W.Easterby[/TD]
[/TR]
[TR]
[TD]N.W.Alexander[/TD]
[/TR]
[TR]
[TD]M.Dods[/TD]
[/TR]
[TR]
[TD]M.Appleby[/TD]
[/TR]
[TR]
[TD]Miss R.Curtis[/TD]
[/TR]
</tbody>[/TABLE]

On a seperate blank sheet, how do i get excel to count each person & how many times they are mentioned without having to manually type them in? There will be more names added to the list everyday & i was wondering if there was a way where Excel would pick them up without me having to type them in. I know easiest way would be to type the name then to count how many times they were used, just wondered if it could be done automatically?

Regards
Steve

 

[DanteAmor]

Create a pivot table

Watch any video about pivot table
https://www.youtube.com/watch?v=caaBoJh9ybA

In your case, drag the name to the area of ​​ROWS and area of VALUES

 

[Fluff]

Or with formulae

Excel 2013/2016
	A	B
1	Name	Count
2	M.P.Tregoning	2
3	S.C.Williams	2
4	W.P.Mullins	9
5	B.M.R.Haslam	1
6	T.D.Easterby	1
7	M.J.Attwater	1
8	Mr M.T.Walford	2
9	Mrs Dianne Sayer	1
10	A.W.Carroll	1
11	R.A.Fahey	6
Sheet2

Cell Formulas
Range	Formula
A2	=IFERROR(INDEX(Sheet1!$A$2:$A$136,MATCH(0,INDEX(COUNTIF($A$1:A1,Sheet1!$A$2:$A$136),0),0)),"")
B2	=IF(A2="","",COUNTIF(Sheet1!$A$2:$A$136,A2))