I have had a search around and i cant find what im looking for as i dont know how to describe it well.
I have a holiday tracker for my staff i have their names listed down the first column and dates across the top. Each holiday is marked as H and Bank Holidays as BH.
What i would like is from that information a formula that i can put in a cell below a staff members name, the formula will find "H" in the corresponding row and show me the date, if i pull down that formula to the next few cells then each cell will find the next H and display the date etc
This will list all the dates a member of staff has booked off by just entering a H into the row hopefully the attached doc will help with the understanding of what i need.
Thank you for any help
Bookmarks