+ Reply to Thread
Results 1 to 4 of 4

Help with employee database

  1. #1
    Registered User
    Join Date
    06-20-2009
    Location
    San Francisco, CA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Help with employee database

    I have in Excel a list of my employees by Name/Race/Gender/Birthdate/Hire date/Salary. There are a couple things I want to do with this information but I can't find out how to do it in the help file or online. I have basic excel 2007 knowledge but nothing advanced. What I want to do is:

    1. Find employees whose salary is between 50000 and 65000. (I'm assuming I can use some kind of formula?)

    2. Find employees who are female and hired before a certain date, for example 1/1/99.

    3. Find the number of employees in each race and income group.

    This is what my table looks like (I changed names for privacy):

    http://i238.photobucket.com/albums/f.../employees.jpg

    Any help would be greatly appreciated.
    Attached Files Attached Files
    Last edited by Timeclock; 06-20-2009 at 07:26 PM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Help with employee database

    Hi Timeclock, welcome to the forum.

    Click on GO ADVANCED and use the paperclip icon to upload sample workbooks instead of pictures. In the file you upload, go ahead and mockup your desired results. Show us how you plan on entering criteria and how you want the answers displayed.

    This makes it very simple to offer clean solutions to your problems.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    06-20-2009
    Location
    San Francisco, CA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Help with employee database

    Thank you for that tip. I edited my original post and a mock-up of what I am trying to do.

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Help with employee database

    Mostly just SUMPRODUCT and some SUMIF().
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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