Re: Excel formula question
- From: "Bernard Liengme" <bliengme@xxxxxxxxxxxxxxxxx>
- Date: Thu, 8 Feb 2007 17:39:43 -0400
I think we need to know how the data is set out.
Is it like this:
Fred 2-feb
George 2-feb
Mary 3-feb
Fred 5-feb
Or
Fred 3-feb 5-feb
Or what?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"blazzzercat via OfficeKB.com" <u30352@uwe> wrote in message
news:6d83b1d562d31@xxxxxx
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.aspx/excel-programming/200702/1
.
- Follow-Ups:
- Re: Excel formula question
- From: Bernard Liengme
- Re: Excel formula question
- From: blazzzercat via OfficeKB.com
- Re: Excel formula question
- References:
- Excel formula question
- From: blazzzercat via OfficeKB.com
- Excel formula question
- Prev by Date: RE: last duplicate value
- Next by Date: Code that keeps creating a toolbar - where might that code be hidden?
- Previous by thread: Excel formula question
- Next by thread: Re: Excel formula question
- Index(es):
Relevant Pages
|
