How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,843
- 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 |