S
storm warden
I am having a little difficulty with the Index / match functions.
I have a spreadsheet set out as follows
Date / Time CC Phase
14/11/2008 20:00:00 INTERRUPT
14/11/2008 20:00:00 B13 RELEASE
14/11/2008 21:00:00 SETUP
14/11/2008 21:10:00 B1B RELEASE
I would like to return the CC for for only when Phase=Release and Date /
Time = 14/11/2008: 20:00:00
Any Advice would be greatly appreciated.
I have a spreadsheet set out as follows
Date / Time CC Phase
14/11/2008 20:00:00 INTERRUPT
14/11/2008 20:00:00 B13 RELEASE
14/11/2008 21:00:00 SETUP
14/11/2008 21:10:00 B1B RELEASE
I would like to return the CC for for only when Phase=Release and Date /
Time = 14/11/2008: 20:00:00
Any Advice would be greatly appreciated.