Hello there,
I'm tracking times in a similar way to this:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sheet 1[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1:00:01[/TD]
[TD]0:59:59[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1:00:02[/TD]
[TD]1:00:02[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1:00:02[/TD]
[TD]1:00:02[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1:00:02[/TD]
[TD]1:00:02[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]1:00:02[/TD]
[TD]1:00:02[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]1:00:02[/TD]
[TD]0:50:50[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sheet 1[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1:00:01[/TD]
[TD]0:59:59[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1:00:02[/TD]
[TD]1:00:02[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1:00:02[/TD]
[TD]1:00:02[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1:00:02[/TD]
[TD]1:00:02[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]1:00:02[/TD]
[TD]1:00:02[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]1:00:02[/TD]
[TD]0:50:50[/TD]
[/TR]
</tbody>[/TABLE]
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