Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 26th 11, 03:46 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2011
Posts: 1
Default counting absentees

name wk1 wk2 wk3 wk4 wk5 wk6 counting backwards, wks missed
a x x x x x A 1
b x x A A x x 0
c x x x x x A 1
d x x x x x x 0
e x x x A A A 3
f x x x x x x 0
g A A A A x x 0
h x x x x A x 0
i x x x x x x 0
j x x A A A x 0
k x x x x x x 0
l x x x A x x 0
m x x x x A A 2

Sorry the spreadsheet didn't copy well!
The answer is in the last column.
This will be a 52 week chart, renewable each year.
Question I'm trying to answer: How many weeks beginning with this
week, has the person missed consecutively? Once an X is reached the
count stops.
Counting from wk6 toward wk 1.

  #2   Report Post  
Old July 26th 11, 04:37 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 1,522
Default counting absentees

On Jul 25, 9:46*pm, Dwayne Gunnels wrote:
name wk1 wk2 wk3 wk4 wk5 wk6 counting backwards, wks missed
a x x x x x A 1
b x x A A x x 0
c x x x x x A 1
d x x x x x x 0
e x x x A A A 3
f x x x x x x 0
g A A A A x x 0
h x x x x A x 0
i x x x x x x 0
j x x A A A x 0
k x x x x x x 0
l x x x A x x 0
m x x x x A A 2

Sorry the spreadsheet didn't copy well!
The answer is in the last column.
This will be a 52 week chart, renewable each year.
Question I'm trying to answer: How many weeks beginning with this
week, has the person missed consecutively? Once an X is reached the
count stops.
Counting from wk6 toward wk 1.


One way

Sub countemupinrev()
For i = 1 To 13
For ii = 6 To 1 Step -1
If Cells(i, ii) = "x" Then
MsgBox i
Cells(i, "H") = 6 - ii
Exit For
End If
Next ii
Next i
End Sub


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting a age Twb Excel Discussion (Misc queries) 3 November 26th 07 09:03 AM
counting function but not double counting duplicates JRD Excel Worksheet Functions 2 November 7th 07 06:43 PM
Counting rows, then counting values. Michael via OfficeKB.com Excel Discussion (Misc queries) 7 August 4th 05 10:57 PM
Counting names in a column but counting duplicate names once TBoe Excel Discussion (Misc queries) 9 May 11th 05 11:24 PM
Detecting absentees gracegift Excel Discussion (Misc queries) 7 December 27th 04 11:35 PM


All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017