+ Reply to Thread
Results 1 to 4 of 4

Fire Department roster from year to year

  1. #1
    Registered User
    Join Date
    10-03-2014
    Location
    Kalamazoo, MI
    MS-Off Ver
    Excel Mac 2011
    Posts
    2

    Red face Fire Department roster from year to year

    I am wondering if I could use department member hire and release dates (busy paid on call department with high turnover rate) to get a snap shot from year to year.
    At any given time, we have x members. If I know the dates they were employed with us, can I use a formula to pull up who was a member on y date?
    For bonus, can I make it spit out the members years of service at that y date?
    Any help would be grateful

  2. #2
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Fire Department roster from year to year

    Can you do some example in excel manually and upload here. Thanks
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
    -If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

    -Always upload a workbook before start your question
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

    +++ If my answer(s) helped you, please add me reputation by click on * +++

  3. #3
    Registered User
    Join Date
    10-03-2014
    Location
    Kalamazoo, MI
    MS-Off Ver
    Excel Mac 2011
    Posts
    2

    Re: Fire Department roster from year to year

    Basically, is there a way to look at our department on 3/15/12 and see how many members we had and what our average years experience was.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Fire Department roster from year to year

    Maybe you can use vlookup function,
    Example:
    G2 = Any name
    H2 =VLOOKUP(G2,A2:E40,4,FALSE) <- lookup Hired Date
    I2 =VLOOKUP(G2,A2:E40,5,FALSE) <- lookup Left Date

    If this is not what you want, perhaps you can do a sample data(manually), then i can think what formula you can use to be done in automatically.
    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatically update year interval cycles from year to year
    By trumptight in forum Word Programming / VBA / Macros
    Replies: 8
    Last Post: 08-21-2014, 10:38 PM
  2. Employee roster for a year
    By paragatre in forum Excel General
    Replies: 24
    Last Post: 12-04-2013, 07:24 PM
  3. Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  4. Fire Department Equiptment Database
    By scuba212 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-14-2013, 06:47 PM
  5. Need help for fire department
    By sta224ffemt in forum Excel General
    Replies: 2
    Last Post: 12-11-2006, 04:16 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1