Formula or way to count repeated data in a list of cells?

I have an excel file that's over 2000 lines deep and has data in 9 different cells across. I want a formula that can find repeated data in a given cell or whole page and total it. lets say I have a column that has first aqnd last names, I want to to find names that were repeated and tell me how many times that name was repeated. or.... Example: list of running cells 1-8 in column E looks like this.
223
342
431
223
512
124
223
013

the number 223 shows up 3 different times right? What I would like is a formula what will search the full page and find copies of this and tell me what they are and how many times they where copied. yes i know you can use the find button and that works if you know what you are looking. the numbers in some of our columns are 6 digits long and we are not sure how many have been used more then once. Or how many times a certain person's name has been entered more then once. thank you and hope you can help.

First thank you for the reply. Second can you explain what you mean in filter all values > 1? I'm a learn as a go, trial and error type when it comes to excel. like I watch youtube videos on how to add up columns so yeah I need some help.

udprocks = That looks like it could work well at least for the column were I have numbers. But will it work where I have names too? I just glanced at it so i have not looked at the formula yet. I will try and add that to my sheet and see what i get. thank you!

Glenn = thats impressive looking (for a rookie like me) I would like to know what all your showing and doing. Maybe that can help me as well and maybe even show me more. So yes I would like to know how that works.

Glenn I'm really sorry for my inability to explain it. I do not know the terminology to use because I am a self taught extreme rookie when it comes to this. I literally did not know how to add cell one and cell two and show the result in cell three when I started this project. Also I do not know how to show or attach a spreadsheet here yet. And last I can not add mine because of HIPPA regulations. I can try and make one similar but not use real names, and attach that. So let me make that and then can you help me attach it?

Ok I am going to try this. If this works you will see a sample of my file as it looks today but very reduced.
tab one "Sheet1" is a running list where the info is input, tab 2"JAN" is for January and you can see that I have copied the info from sheet one into
JAN. same for Tab 2 "FEB", and tab 3 "MAR". all of these are the same and as each month ends i copy and past that info from sheet one into the corresponding month

For starters I want to use columns at the top (marked in blue). Duplicate ID# and Duplicate Names.
starting with Duplicate ID# column I want it to show how many times the same number showed
up within the ID column. and in the Duplicate Names I want it to show how many times the same name showed up more then once.

Then in each month I want to show that as well when I copy that info into that tab.
I would also like for it to show in the totals tab a running total. of how many times a certain number and or name showed up in each month and year.
this part I have not even started yet because I was not sure it can even be done.

then last I want to be able to save all of the layouts, and formulas and be able to start over with a whole new sheet on January 1st. 2018.

PS.. some of the formulas are not going to work because of all the changes I made to get this edited down to be able to send. if you can just show me how to do the things I wuld like
I will add them to my master sheet and hopefully that will work.
thank you!

Originally Posted by Glenn Kennedy

Is this it? What are the criteria for deciding whether an entry belongs in Jan feb, etc. It's easy to get a fomrula to do the copy/pasting for you...

The date out. If the date out is 01/04/17 then it goes into JAN. if the date is 02/22/17 then it goes into FEB. etc. I have just been highlighting and selecting the ones that fill into that months date out and click copy and then past that into JAN. HOWEVER when i do that it moves all the totals and formulas that are in the last columns (the ones I want to stay in each tab columns K,L,M) down however many I just pasted into that tab. Lets say i have 129 that i bring over from sheet 1 to tab JAN. Then the data i have put into K,L,M will move down 129 rows. I have to delete the rows above them and redo the formula each time.

I'm sorry i just looked and on this test file its Columns M,N,O in tabs JAN, FEB, MAR, that move when I copy and paste. If you notice I have a couple boxes that total up the info for that month. shows me turn a round, who did what and how many they did, what all came in, etc... I'm trying to use these to show me as much as I can about everything coming and going as i can get it to.

OH AND YES that looked to work on getting the duplicates for both thank you! I wonder now if there is a way to give me a total for the end of the year? a column that shows that John Doe 22 was listed 6 times each month for a total of 18 times?