I would appreciate help with the following problem with an Excel worksheet I am working on. Column Z is a column of numbers representing hours absent from work for any of 3 different reasons, column X contains alfa codes for the reason; A/L for annual leave, S for sickness and S/D for study time. I need to extract from col Z the hours relating only to annual leave to enable entitlement calculations to be made. Any help would be much appreciated. Thank you.