Hi everyone, I've been a long time lurker, but this is my first post.
I have this formula I'm looking for, but can't seem to crack - it's stumped me and I hope someone here can help.
I'm doing a scheduling project where I have set up 1/2 increments as the column headings, I have job titles as my row headings and I input a persons name in the data section for the units they work.
I'm trying to summarize start times for the day and am trying to set up a formula that will return the top row (start time) for the person.
So, the chart would look like this:
- Column A Column B Column C
Row 1 1/2 hour units 7:30 AM 8:00 AM
Row 2 Clerk 1 Bob Steve
Row 3 Clerk 2 Joe Tom
I'm trying to create a formula that says: if Tom is in Column B, then return B1. In this case the answer would ne "null" because Tom is in Column C. But if I wrote the formula for Joe in Column B, the answer would be "7:30 AM".
I just can't figure this one out.
Thanks for your help.
Bookmarks