Don't know what functions to use....

[Trip Poly]

Hi...the end result that I am trying to accomplish is to list the names of my
employees that I have scheduled for each day.

A1 holds their names
B1 thru O1 hold the times that they should come in to work.

In another sheet I am trying to see if they work on "Monday" in B1 of schedules
sheet and if they are working I want it to pull the name from A1. I need this
to list the names of the people that are working.

Schedule Sheet

Mon Tue Wed .......
Tom Am Pm
Steve Am
Lisa Pm Pm
Fred Am Am Pm
.......


List Sheet

MonAm MonPm TueAm TuePm WedAm WedPm
Tom Lisa Steve Tom Lisa
Fred Fred Fred


Is this possible?

TIA

 

[Harlan Grove]

Trip Poly wrote...

Hi...the end result that I am trying to accomplish is to list the names of my
employees that I have scheduled for each day.

A1 holds their names
B1 thru O1 hold the times that they should come in to work.

In another sheet I am trying to see if they work on "Monday" in B1 of schedules
sheet and if they are working I want it to pull the name from A1. I need this
to list the names of the people that are working.

Schedule Sheet

________Mon___Tue___Wed...
Tom____ Am___ Pm_______
Steve__________Am_______
Lisa____ Pm__________ Pm
Fred____Am____Am____Pm
....

Don't use spaces or tabs to format tables in newsgroup postings. Some
people view postings in fixed width typefaces while others view them in
proportional typefaces. Use mostly underscores, _, with a few spaces.
Not perfect, but much better generally.

List Sheet

MonAm__MonPm__TueAm__TuePm__WedAm__WedPm
Tom_____Lisa_____Steve___Tom_____________ Lisa
Fred_____________ Fred____________________ Fred

Is this possible?

Name the Schedule table ST. With the top row of your List sheet table
in A1:AB1 (14 columns from Schedule table * 2 time periods [AM or PM] =
28, the number of columns spanned by A1:AB1), enter the following array
formula in List!A2.

List!A2 [array formula]:
=IF(COUNTIF(INDEX(ST,0,MATCH(LEFT(A$1,3),
INDEX(ST,1,0),0)),RIGHT(A$1,2))>=ROWS(A$2:A2),
INDEX(ST,MATCH(1,(COUNTIF(A$1:A1,INDEX(ST,0,1))=0)
*(INDEX(ST,0,MATCH(LEFT(A$1,3),INDEX(ST,1,0),0))=RIGHT(A$1,2)),0),1),"")

Fill A2 right into B2:AB2, then select A2:AB2 and fill down as far as
needed.

 

[Trip Poly]

Thanks....will try tonight!

Trip Poly wrote...

Hi...the end result that I am trying to accomplish is to list the names of my
employees that I have scheduled for each day.

A1 holds their names
B1 thru O1 hold the times that they should come in to work.

In another sheet I am trying to see if they work on "Monday" in B1 of schedules
sheet and if they are working I want it to pull the name from A1. I need this
to list the names of the people that are working.

Schedule Sheet

________Mon___Tue___Wed...
Tom____ Am___ Pm_______
Steve__________Am_______
Lisa____ Pm__________ Pm
Fred____Am____Am____Pm
....

Don't use spaces or tabs to format tables in newsgroup postings. Some
people view postings in fixed width typefaces while others view them in
proportional typefaces. Use mostly underscores, _, with a few spaces.
Not perfect, but much better generally.

List Sheet

MonAm__MonPm__TueAm__TuePm__WedAm__WedPm
Tom_____Lisa_____Steve___Tom_____________ Lisa
Fred_____________ Fred____________________ Fred

Is this possible?

Name the Schedule table ST. With the top row of your List sheet table
in A1:AB1 (14 columns from Schedule table * 2 time periods [AM or PM] =
28, the number of columns spanned by A1:AB1), enter the following array
formula in List!A2.

List!A2 [array formula]:
=IF(COUNTIF(INDEX(ST,0,MATCH(LEFT(A$1,3),
INDEX(ST,1,0),0)),RIGHT(A$1,2))>=ROWS(A$2:A2),
INDEX(ST,MATCH(1,(COUNTIF(A$1:A1,INDEX(ST,0,1))=0)
*(INDEX(ST,0,MATCH(LEFT(A$1,3),INDEX(ST,1,0),0))=RIGHT(A$1,2)),0),1),"")

Fill A2 right into B2:AB2, then select A2:AB2 and fill down as far as
needed.