|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
Excel Ranges & LEFT
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
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.
|Thread||Thread Starter||Forum||Replies||Last Post|
|excel spread sheet wont caculate new data entered in ranges.||Art-needs-help||Excel Discussion (Misc queries)||3||November 8th 05 02:06 PM|
|AHHHH-Get Data from Multiple Excel workbooks||JAA149||Excel Discussion (Misc queries)||5||October 30th 05 05:19 PM|
|Excel; How do I reverse the chart? 'A' on the left, etc.||Doctor Duck||Charts and Charting in Excel||0||September 11th 05 12:37 PM|
|Excel VB-Copy formula down until adjacent cell (left) is blank?||Tony P.||Excel Discussion (Misc queries)||1||May 18th 05 06:11 PM|
|Using LEFT, can excel produce the first 0's in a custom format?||kanye||Excel Discussion (Misc queries)||4||April 29th 05 02:58 PM|