Formula to recognize consecutive entries
Hi,
I am creating a schedule and need to find a way (formula?) for excel to recognize if a person has been scheduled more than 5 days in a row. I have a basic set up of the days of the week (2 weeks) across the top and names down the first column. I enter the shift number under the days they are scheduled to work. Any suggestions?
Post an example workbook as an attachment.
That's my first suggestion. :D
We'll get ya all set up once we can see what we're doing.
mew!
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Re: Formula to recognize consecutive entries
Here is is...thanks for the advice. It is a very brief sample with the same concept.
Laura
Try...
P3, confirmed with CONTROL+SHIFT+ENTER, and copied down:
=SUM(IF(FREQUENCY(IF(B3:O3<>"",COLUMN(B3:O3)),IF(B3:O3="",COLUMN(B3:O3)))>5,1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks