How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,836
- Office Version
- 2010
- Platform
- Windows
Here is a sample of my data, "Monday" will appear more than once in Column B but there will only be one Monday with "3" in Column A... How would I return the "01:05:03" to G2 please?
| Excel Workbook | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | Helper | Day | Duraton | Helper | Day | Duration | |||
| 2 | 9 | Saturday | 00:57:47 | 3 | Monday | ||||
| 3 | 8 | Sunday | 00:58:42 | ||||||
| 4 | 3 | Monday | 01:05:03 | ||||||
| 5 | 9 | Tuesday | 00:56:28 | ||||||
Sheet1 | |||||||||
