Is there a way to look up the second occurrence of a value in a row?
https://drive.google.com/file/d/0B0392ULavezpbktIY29ST3kzWVU/view?usp=sharing
I've created an example on the link above - hopefully you can access it.
I have staff names across the column headings, and the data in the rows...