Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
PaulGrowns1
 
Posts: n/a
Default How do I find how often a number appears within a worksheet

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.
  #2   Report Post  
John Moore
 
Posts: n/a
Default

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I find the sum of all digits in a number? monkeyforce5 Excel Discussion (Misc queries) 4 September 9th 05 09:49 PM
How do I find a missing number in a sequence of numbers? Nash Excel Worksheet Functions 2 August 11th 05 04:22 AM
Find the number of rows returned in a filter Tony W Excel Discussion (Misc queries) 5 May 30th 05 10:36 PM
Find number of days between to dates Qaspec Excel Worksheet Functions 1 January 21st 05 12:14 AM
How do I find highest number in a row and change color? pamstolen Excel Worksheet Functions 3 January 18th 05 12:35 AM


All times are GMT +1. The time now is 02:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"