| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting times a value occurs
I'm sure I'm an idiot but I can't get this to work. I need to have the code
count the number of times a name occurs in a given selection. The code below should give you an idea of what im working on, column 15 is a list of employees and if the month its calculating is may then the range below is the range inwhich the employee could be scheduled in may. If UserForm1.calcMay.Value = True Then EmployeeRow = 2 Do Until ActiveSheet.Cells((EmployeeRow + 1), 15).Value = Empty EmployeeRow = EmployeeRow + 1 employee = ActiveSheet.Cells(EmployeeRow, 15).Value shifts = Range("A4:N8,A10:N14,A16:N20,A22:N26,A28:F32"). Count(employee) ActiveSheet.Cells(EmployeeRow, 16).Value = shifts * 8 Loop Thanks for the help, jordan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting number of times name occurs between two dates | Excel Worksheet Functions | |||
| counting no. of times a character occurs in a cell | Excel Worksheet Functions | |||
| Counting number of times a value occurs | Excel Discussion (Misc queries) | |||
| Counting the number of times more than 1 variable occurs | Excel Discussion (Misc queries) | |||
| I would like to count the # of times a value occurs in Col B base | Excel Worksheet Functions | |||
Threaded Mode
