Hi all,
On the attached spreadsheet, I need to transpose the Total Shift time from the Data tab onto the Summary tab.
Hopefully that bit is pretty simple?
However, the raw data may not always be in alphabetical, sequential order so I need the formula to be flexible enough to look through the entire data sample and figure out the correct result wherever the Driver name appears on the list.
I assume it's somehow Index/Match related but I'm stumped.
Thanks,
Bookmarks