Hello there,
I'm tracking times in a similar way to this:
<tbody>
</tbody>
I will have this for exactly 11 tabs, and my goal is to display the 5 (or 10) lowest times in a column on a separate sheet.
The times will always be in the cells C2:D7 and finding the lowest time using the MIN-operator is no big deal.
However, I have trouble displaying the 2nd lowest time. Using SMALL doesn't seem to work because I can only enter 1 array, and I can't find another way to do it.
Using
also doesn't work.
Useful info (?): I'm working on a Google Spreadsheet and I can't use VBA
I'm tracking times in a similar way to this:
Sheet 1 | C | D |
2 | 1:00:01 | 0:59:59 |
3 | 1:00:02 | 1:00:02 |
4 | 1:00:02 | 1:00:02 |
5 | 1:00:02 | 1:00:02 |
6 | 1:00:02 | 1:00:02 |
7 | 1:00:02 | 0:50:50 |
<tbody>
</tbody>
I will have this for exactly 11 tabs, and my goal is to display the 5 (or 10) lowest times in a column on a separate sheet.
The times will always be in the cells C2:D7 and finding the lowest time using the MIN-operator is no big deal.
However, I have trouble displaying the 2nd lowest time. Using SMALL doesn't seem to work because I can only enter 1 array, and I can't find another way to do it.
Using
Code:
[COLOR=#000000][FONT=Inconsolata]=[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]SMALL[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#F7981D][FONT=Inconsolata]'Sheet 1'!C2:D7[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#7E3794][FONT=Inconsolata]'Sheet 2'!C2:D7[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][FONT=Inconsolata][COLOR=#1155cc]2[/COLOR][/FONT][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR]
Useful info (?): I'm working on a Google Spreadsheet and I can't use VBA