VB and nested if statements

Originally Posted by timmycl_7

Hi,

I've got an excel worksheet and I want to add some conditions to a range of cells (Column). The conditions are as follows -

1) Three or more occasions off sick in a 12 week period,

2) six occasions off sick in a rolling year

c) 3 to 5 occasions of sickness absence totaling twelve or more days in a rolling year

Firstly do you know if this is possible in excel, if so would it involve using VB and nested if statements be the be way

Regards

Hi,
try the auto filter

Originally Posted by timmycl_7

Autofilter won't work because the sheet is about 1000 cells. I was hoping I could isolate a twelve week period and a year. Would I have to think about a seperate worksheet for each year??

And why won't it work?