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 .....

IF Formula for string of cells
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide
Count if cell contains number - Excel Forum
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Based on the values in cells b77 b81 ✓ - Excel Forum

1 response

Answer 1 / 1

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.

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

Compare values in two columns and return the value from third

How to calculate position (1st,2nd,3rd) in excel....?

formulas for 1st and 2nd position in class

Calculation of positions in excel

Similar discussions

Subscribe To Our Newsletter!