Find repeating numbers in a sheet

We schedule approx. 30 employees Monday to Sunday

We use a simple spreadsheet, with the working employee's number under the scheduled time for a 2 week period. This is a simple example:


January 06:30 07:00 09:00 10:00 12:00 14:00

1 100 101 102 103 104 105
2 107 109 101 110 104 105
3 100 103 104 111 105 112
etc. for 14 days.


I would like to display how many times an employee's number has been entered in the 14 day period.

Example:
100 =2
101 =2
103 =2
104 =3
105 =3
etc.

also, see attached file.
Thanks

Hello,

Use COUNTIF, like

=COUNTIF(B2:G15,J2)

Where J2 contains the employee #.

If you can attach a dummy file, would be better.

B7, copy down

=COUNTIF($B$2:$G$4,A7)