Index/match question.
I have to sheets is a work book.
WS1 A2 = Group Name B2 = Date and Case Start in text format C2 = Surgeon Name D2 = Blank E2 = Date of Surgery F2 = Day of Week H2 = Date in Text I2 = OR Room Number J2 = Case Start Time K2 = Case End Time L2 = Total Minuties Next three colums JKL in text format WS2 A2 = GROUP B2 = BLOCK OR (room reserved, this doens't matter, they use what room is available) C2 = DATE (date in which the group/surgeons reserved time will fall on (E2) D2 = DATE TEXT E2 = WEEKS (week of the month inwhich the group or surgeon has reserved time) F2 = DOW G2 = BLOCKST H2 = BLOCKEND In worksheet one, I need to show the cases being preformed are during the surgeons/groups reserved time. If it is not, I can show what is being done outside of the time reserved, perhaps conditional formating...? I need to match group or surgeon in worksheet one with an indicator that falls within the peramiters in WS2. I am thankful for any help. Jules -- Jules |
All times are GMT +1. The time now is 03:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com