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
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 .....
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 .....
Related:
- IF Formula for string of cells
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
linked4me
Posts
9
Registration date
Wednesday November 5, 2008
Status
Member
Last seen
May 16, 2009
Jan 26, 2009 at 07:14 AM
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.
try this link to get formulas for excel:
http://www.cpearson.com/excel/excelF.htm
hope it helps you.