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 |
All times are GMT +1. The time now is 06:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com