Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Ranges & LEFT
Hi all,
I need to search a range of cells (eg a1:aa50) for a shift start time (08:00), and count the number of times the start time appears, displaying this in another cell. Each column is a staff member, plus additional columns are for temporary staff. Each row is a seperate date, and may have none, one, two or more of each starting time. I need to check, by date, that the shift is covered by the right number of staff, either permenant and/or temps. However, some of the shifts will have additional info (temp staff initials) eg 08:00 SH). I can search the ranges using COUNTIF, but I also need to utilise the LEFT function, to only pick out the start times. Any help would be gratefully received. Cheers Stu |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel spread sheet wont caculate new data entered in ranges. | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Excel; How do I reverse the chart? 'A' on the left, etc. | Charts and Charting in Excel | |||
Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
Using LEFT, can excel produce the first 0's in a custom format? | Excel Discussion (Misc queries) |