How do I find how often a number appears within a worksheet

[PaulGrowns1]

I am a vehicle fleet service manager. Basically I have two work sheets. One
contains all personal information with regards to the workforce the other
contains the details of the vehicles, mileage and the person who has used the
vehicle.

I basically need to know how often a person fills in the mileage books
without wading through vast amounts of data.

[John Moore]

Paul ,,, Try COUNTIF ,,,,, should work

"PaulGrowns1" wrote:

> I am a vehicle fleet service manager. Basically I have two work sheets. One
> contains all personal information with regards to the workforce the other
> contains the details of the vehicles, mileage and the person who has used the
> vehicle.
>
> I basically need to know how often a person fills in the mileage books
> without wading through vast amounts of data.