Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with formula ("IF"?)
Hello,
I have a spreadsheet listing all employees and other data (birth date, hire date, department name, etc.). I need a separate sheet for each department within the same book. For example, all Administration in one sheet, all Engineering in another, etc. My data ranges from A2:0141 (headings are in row 1). What is the formula to pull each department into it's own sheet? The departments are in column F. Thank you. -- MB |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with formula ("IF"?)
It is very poor database management practice to have duplicate data. I
believe everything you want to do could be accomplished using Data Auto Filter best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MB" wrote in message ... Hello, I have a spreadsheet listing all employees and other data (birth date, hire date, department name, etc.). I need a separate sheet for each department within the same book. For example, all Administration in one sheet, all Engineering in another, etc. My data ranges from A2:0141 (headings are in row 1). What is the formula to pull each department into it's own sheet? The departments are in column F. Thank you. -- MB |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with formula ("IF"?)
I tried auto filter, but I have the following in columns P through S
Lower Upper Range Count 0 5 0-5 (formula here) 6 10 6-10 11 15 11-15 (through to 35+) This is needed to chart how many years in each range group. I have the same in columns T through W that calculates age groups. When I filter the department column, it filters these columns, too. I need a chart for all employees and then a separate chart for each department. I can't figure out how to do this. Thank you. MB "Bernard Liengme" wrote: It is very poor database management practice to have duplicate data. I believe everything you want to do could be accomplished using Data Auto Filter best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MB" wrote in message ... Hello, I have a spreadsheet listing all employees and other data (birth date, hire date, department name, etc.). I need a separate sheet for each department within the same book. For example, all Administration in one sheet, all Engineering in another, etc. My data ranges from A2:0141 (headings are in row 1). What is the formula to pull each department into it's own sheet? The departments are in column F. Thank you. -- MB |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with formula ("IF"?)
Not sure what you mean by "it filters these column too"
You can select ALL for each of these to show all records for any one department. You do have a top row with column headers such as "Department", etc? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MB" wrote in message ... I tried auto filter, but I have the following in columns P through S Lower Upper Range Count 0 5 0-5 (formula here) 6 10 6-10 11 15 11-15 (through to 35+) This is needed to chart how many years in each range group. I have the same in columns T through W that calculates age groups. When I filter the department column, it filters these columns, too. I need a chart for all employees and then a separate chart for each department. I can't figure out how to do this. Thank you. MB "Bernard Liengme" wrote: It is very poor database management practice to have duplicate data. I believe everything you want to do could be accomplished using Data Auto Filter best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MB" wrote in message ... Hello, I have a spreadsheet listing all employees and other data (birth date, hire date, department name, etc.). I need a separate sheet for each department within the same book. For example, all Administration in one sheet, all Engineering in another, etc. My data ranges from A2:0141 (headings are in row 1). What is the formula to pull each department into it's own sheet? The departments are in column F. Thank you. -- MB |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with formula ("IF"?)
Hi Bernard,
Yes I have column headings, as follows: A Employee # B Full Name C Last Name D First Name E Mid Initial F Department G Position H Hire Date I Birth Date J Years Worked (calculated field) K Current Age (calculated field) L Years until retirement (calculated field) M Lower N Upper O Range P Count (the above is for charting years until retirement) Q Lower R Upper S Range T Count (Columns Q-T is for charting age groups) When filtering "Department" columns M through T loses some rows. Thank you, Bernard. -- MB "Bernard Liengme" wrote: Not sure what you mean by "it filters these column too" You can select ALL for each of these to show all records for any one department. You do have a top row with column headers such as "Department", etc? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MB" wrote in message ... I tried auto filter, but I have the following in columns P through S Lower Upper Range Count 0 5 0-5 (formula here) 6 10 6-10 11 15 11-15 (through to 35+) This is needed to chart how many years in each range group. I have the same in columns T through W that calculates age groups. When I filter the department column, it filters these columns, too. I need a chart for all employees and then a separate chart for each department. I can't figure out how to do this. Thank you. MB "Bernard Liengme" wrote: It is very poor database management practice to have duplicate data. I believe everything you want to do could be accomplished using Data Auto Filter best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MB" wrote in message ... Hello, I have a spreadsheet listing all employees and other data (birth date, hire date, department name, etc.). I need a separate sheet for each department within the same book. For example, all Administration in one sheet, all Engineering in another, etc. My data ranges from A2:0141 (headings are in row 1). What is the formula to pull each department into it's own sheet? The departments are in column F. Thank you. -- MB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Formula to sum up data using "if" function?? | Excel Discussion (Misc queries) | |||
"IF" Formula Query... | Excel Worksheet Functions | |||
How do I use the "if" and "round" function in the same formula ? | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel |