IF Formula for string of cells

Closed
Gwids - Jan 26, 2009 at 05:09 AM
linked4me Posts 9 Registration date Wednesday November 5, 2008 Status Member Last seen May 16, 2009 - Jan 26, 2009 at 07:14 AM
Hi,

I am creating a timesheet for my team and have a problem. Currently staff members select an abbreviation of their name from a drop down on a sheet with all the days of the year on it, and that populates other sheets with other data.

I want to be able to note when staff take 10 consecutive days off, so want a formula to return a certain value if, in a whole sheet, there are ten consecutive cells within any set of 12 (weekends) that are the same value.

Has anyone any ideas on how to help ? Thanks .....

1 reply

linked4me Posts 9 Registration date Wednesday November 5, 2008 Status Member Last seen May 16, 2009
Jan 26, 2009 at 07:14 AM
hi,

try this link to get formulas for excel:

http://www.cpearson.com/excel/excelF.htm

hope it helps you.
0