jazz2409
06-18-2020, 08:23 AM
Hello, the attached file shows which weeks each client has data on raw sheet. However my def&calc sheet has start and end week columns.
What I am trying to do is put NA on weeks before the indicated start week, N on weeks with no data and Y on weeks with data.
Then on the indicated week start date will either be N or Y depending on whether they have data on raw sheet or not.
Also if there's a week end date all weeks after the week end date will be NA.
If the week start and end dates are empty it should carry on with putting Y or N depending on whether they have data or not in raw sheet
My code only does the Y and N. I don't know how to do the NA part.
Also, the NA weeks won't be part of the averaging, just the Y and N
Please help thank you
What I am trying to do is put NA on weeks before the indicated start week, N on weeks with no data and Y on weeks with data.
Then on the indicated week start date will either be N or Y depending on whether they have data on raw sheet or not.
Also if there's a week end date all weeks after the week end date will be NA.
If the week start and end dates are empty it should carry on with putting Y or N depending on whether they have data or not in raw sheet
My code only does the Y and N. I don't know how to do the NA part.
Also, the NA weeks won't be part of the averaging, just the Y and N
Please help thank you