Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Our company provides quarterly employee reviews.
What would be the best function to use in the following scenario: We create (re-use) a monthly spreadsheet of employees, title, department, main duties, & contact information. We have a list of titles & departments (on a separate tab) divided by the month that the title or department is due for review: Column A:JANUARY ADMINISTRATIVE ASSISTANTS PAYROLL Column B: FEBRUARY INTERNS MARKETING We want to add a column to the far left of the monthly spreadsheet so that each employee has a cell to indicate if they are up for review. Review? Name Title Department Duties Phone Email R TEST PERSON ADMINISTRATIVE ASST. ADMINISTRATIVE DUTIES x-1234 Would an IF or VLOOKUP function be best for this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create list based on data table | Excel Discussion (Misc queries) | |||
sum cells based on contents of adjacent cell (validated list)? | Excel Worksheet Functions | |||
Create filename based on cell contents | Excel Worksheet Functions | |||
How to create a formula 5 to 10% based on given list of price | Excel Worksheet Functions | |||
Create List based on cell data | Excel Discussion (Misc queries) |