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
Number to words in excel formula - Guide
Excel formula if cell contains text then return value in another cell ✓ - Excel Forum
Excel grade formula - Guide

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

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

Compare values in two columns and return the value from third

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!