View Single Post
 
Old 08-29-2011, 12:45 AM
nutrastat nutrastat is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Aug 2011
Location: Brighton, UK
Posts: 36
nutrastat is on a distinguished road
Default Separate Requirement Into Separate Weeks?

Good Morning,

Well, it took some thinking about because I do not know how to deal with arrays. Attached you will find a file, that although not an elegant solution, is a least a solution to your problem.

What I have done is created a range for Week_01, then using a horizontal look up, looked down to see whether the Sunday cell was an 'A' or zero and giving a result of 0, or 1. You will need to do the same for the remaining weeks.

Hope this helps.
Attached Files
File Type: xls Nutrastat Employee Snippet (1).xls (42.5 KB, 12 views)
Reply With Quote