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.
Bookmarks