Home |
Search |
Today's Posts |
#1
|
|||
|
|||
please help
wonder if someone can help me out?
Please look at this information below: Each individual has a some kind of a skill set. Each individual is scheduled certain day (light brown table) I would like to build a formula which would allow me to find out how many particular skillsets I have in each day. This is what would be for one single cell. =IF(AND(IF(Z15=1,1,0),IF(W15=1,1,0)),1,"") This is a logical value(TRUE equals 1). for each person I would need a cell to have this formula and sum it up for all of them. This task using this method would require if there was 15 people , 15 cells times 6 days, times 10 skills, just to sum it up to one number. Imagine 157 people!!! As you see I need some serious help from you guys. thank you very much. Robert |
#2
|
|||
|
|||
Sounds like you should investigate pivot tables. Look them up in help.
-- HTH RP (remove nothere from the email address if mailing direct) "robert dydo" wrote in message news:C_PRe.353158$s54.337084@pd7tw2no... wonder if someone can help me out? Please look at this information below: Each individual has a some kind of a skill set. Each individual is scheduled certain day (light brown table) I would like to build a formula which would allow me to find out how many particular skillsets I have in each day. This is what would be for one single cell. =IF(AND(IF(Z15=1,1,0),IF(W15=1,1,0)),1,"") This is a logical value(TRUE equals 1). for each person I would need a cell to have this formula and sum it up for all of them. This task using this method would require if there was 15 people , 15 cells times 6 days, times 10 skills, just to sum it up to one number. Imagine 157 people!!! As you see I need some serious help from you guys. thank you very much. Robert |
#3
|
|||
|
|||
Unfortunately not.
Skill data is under column labels, so is the schedule. Rows labels are actual names. The result I am looking for is if someone works on Monday, what kind of skills they bring in. So if I have 100 people on schedule for Monday I have that much of skills from 11 possibilities of skills. thanks EXAMPLE DAYS OF THE WEEK NAMES Skills A B C D E F G H I J K MO TU WE TH FRI SA JOHN 1 1 1 1 1 1 1 1 1 TOM 1 1 1 1 1 1 1 1 1 1 BARB 1 1 1 1 1 1 1 1 1 1 1 1 1 Result: Mo Tu We Th Fr Sa total skills A 1 2 2 2 1 1 total skills B 1 2 2 2 1 1 total skills C 1 2 2 2 1 1 total skills K 2 2 3 3 2 2 "Bob Phillips" wrote in message ... Sounds like you should investigate pivot tables. Look them up in help. -- HTH RP (remove nothere from the email address if mailing direct) "robert dydo" wrote in message news:C_PRe.353158$s54.337084@pd7tw2no... wonder if someone can help me out? Please look at this information below: Each individual has a some kind of a skill set. Each individual is scheduled certain day (light brown table) I would like to build a formula which would allow me to find out how many particular skillsets I have in each day. This is what would be for one single cell. =IF(AND(IF(Z15=1,1,0),IF(W15=1,1,0)),1,"") This is a logical value(TRUE equals 1). for each person I would need a cell to have this formula and sum it up for all of them. This task using this method would require if there was 15 people , 15 cells times 6 days, times 10 skills, just to sum it up to one number. Imagine 157 people!!! As you see I need some serious help from you guys. thank you very much. Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|