S_T_E_V_E_N
New Member
- Joined
- Jun 9, 2020
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
I am struggling a bit, I have a problem. I would like to pull through specific information from a colom. If the cell with the name (Steven) is picked up for example with a specific IF function then I want it to analyse the row and look for the "Start" Text and pull through the time right next to it. I would like the same to happen for the "End" Function. I basically want my document to basically to pull through the start and the end times.
Please note that I need the formulae to highlight an entire colom because I have these reports all bunched up on one page. That's why the formulae must only analyse the information once the name is picked up.
The end result will be pulled through to a summary.
Thank you to whomever helps.
Please note that I need the formulae to highlight an entire colom because I have these reports all bunched up on one page. That's why the formulae must only analyse the information once the name is picked up.
The end result will be pulled through to a summary.
Thank you to whomever helps.
Steven | ||||
Start | 7:58:31 AM | 3:02:22 PM | ||
8:05:03 AM | 3:39:49 PM | |||
8:09:59 AM | End | 4:12:28 PM |