Screen Shot 2015-02-23 at 12.52.27 PM.png
Goal:
In each row that has Column 3 be "B753", column 7 = "no", and column 9 blank (""), I need to take the higher of column 4 or 5 (shown in bold, with the lesser in strikethrough) and sum them all.
In the example here the sought answer is 2:58 + 5:34.
I have about 100 row to look through.
I don't think this can be done in a vector, but rather an array.
Anyone?
Bookmarks