LinkBack URL
About LinkBacks
Since you are varying both rows and columns, try using INDEX/MATCH
In M20 copied across and down
=IF(LEN(INDEX($D$3:$R$8, MATCH($J20,$A$3:$A$8,0),MATCH($L$16, $D$1:$R$1,0)+COLUMNS($A$1:A$1)-1))>0,1,"")
Does that work for you?
Since you are varying both rows and columns, try using INDEX/MATCH
In M20 copied across and down
=IF(LEN(INDEX($D$3:$R$8, MATCH($J20,$A$3:$A$8,0),MATCH($L$16, $D$1:$R$1,0)+COLUMNS($A$1:A$1)-1))>0,1,"")
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi
First thanks Chemistb for your reply.
That works great for inputting the results in the table for the people in the tracker. Butthe employee names are not constants I need them to be imported into the recieving table only if they are absent for any day for the specified week.
If I enter week 1 bill has no entries (he is in work all week) so he should not be in the recieving table (TRACKER) same for week 2.
if I enter week 2, Bill, Tom & Cath have no entries so they should not be in the tracker.
However
If I enter week 3 bill has an "off" day on Wed so his name should then enter the tracker but Tom, Sam & Sue have no entries so they should not.
Hope this makes sense.
I only want employees in the tracker if they are off during the week specified.
I think I may have to do this in two steps ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks