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 .....
Configuration: Windows 2000 Internet Explorer 6.0
Hi,
|
Copy formula multiple cells vba Excel - how to use if formula for rows Excel blank cell if no formula item Excel formula copy cell if match Excel formula to see if a cell is lessthan or greater than Excel if statement string Excel using if formula returning a value if a string is within a cell Format a cell if a different cell conatians How to change a cell color with if formula in excel How to use 'if' formula with three conditions How to use if formula with a table If formula false go to next cell If value in cell in the column matches other value cell in the same column Mailto mail address formula from cell Same if formula multiple cells excel Show formula in cell in excel Using date on if formula Vba vlookup if cell is a string