| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula question
This is for an Excel attendance worksheet. Entries are made for each day an
employee calls in as being absent (calloff). What I am looking for is if 2 €œcalloffs€ happen in a row they only count as 1 €˜Occurrence (multiple day call ins only count as 1 occurrence.) If employee calls off on Feb 2 and calls again on Feb 3, this in only one €˜Occurrence (they are only allowed 3 occurrences). But if they call in on Feb 5th this is a 2nd occurrence. I am looking for a formula to automate the counting of occurences. Thanks so much. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200702/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula question | Excel Discussion (Misc queries) | |||
| Excel Formula Question! | Excel Discussion (Misc queries) | |||
| Formula Question for Excel | Excel Discussion (Misc queries) | |||
| Excel formula question. | Excel Worksheet Functions | |||
| Question about a formula (Excel XP) | New Users to Excel | |||
Threaded Mode
