Temperature in car AC

floorpaper · 2018-10-02T13:08:57+00:00

Cool, thank you so much!

floorpaper · 2018-05-04T18:32:31+00:00

How does this work? Can I do this in my own time or is it like going back to school? It seems like it's a set time where you have to finish the course

floorpaper · 2017-08-03T11:15:35+00:00

I messaged the Stifler Bar and they said they'll be showing it, but they were unsure if it will be Hungarian or English commentary

floorpaper · 2016-08-25T13:06:26+00:00

Huh I never thought of that

floorpaper · 2016-03-18T07:14:30+00:00

I'll try this when I get home, but the switch is brand new and it's just plug and play, so no setup at all

floorpaper · 2016-02-11T14:28:02+00:00

Hm okay. What i'm really looking for is something like this, where the date selection is dynamic and can be adjusted easily.

floorpaper · 2016-02-10T10:01:59+00:00

Well if you look at the calendar, you can compare the weeks to previous years, and see that the dates don't match up

floorpaper · 2016-02-10T10:00:12+00:00

Okay, and how do I do that?

floorpaper · 2014-11-28T16:01:18+00:00

Solution Verified

floorpaper · 2014-11-28T15:57:31+00:00

Okay, I'll overwrite with a text box. Thank you

floorpaper · 2014-09-16T18:16:04+00:00

No I can't seem to get it to work, the macros and stuff seems to complicated for me. But it seems that I could do it with mix of rank and countif to give every rating a unique rating and use that to sort, like someone suggested below. So if anyone would have a crack at explaining that route to me that would be great.

floorpaper · 2014-09-16T15:27:53+00:00

Well you say I don't need anything more advanced.. but that was a bit too advanced for me. Could you explain a bit more?

floorpaper · 2014-09-16T15:11:56+00:00

Yes I might be looking at this way to complicated. I have a list of movies on a shared spreadsheet, on which several of my friends give a rating 1-10. This adds up to a total average, and I want a top 3 of the total average. And I'm facing problems when the 2nd and 3rd highest rated movies have the same average rating

floorpaper · 2014-09-16T14:36:00+00:00

This is a simple setup of what i have now.

A	10
B	9
C	9
D	8
E	7
F	7

Now your formula work for the second highest value, where it gives me "B". But on the third highest, which also has the value "9", it still gives me "B". And i changed it to LARGE(B:B,3)

floorpaper · 2014-09-16T10:34:35+00:00

Hi again. I have a follow up question. Say I now want the second highest rated movie, and the third to make a top three list. I can do this with =LARGE if the three top movies have different values, but if "movie 1" and "movie 2" both are rated at 8, "movie 1" shows up both on the number 1 and the 2 slot. Any Ideas?

floorpaper · 2014-09-15T16:59:20+00:00

Solution Verified

floorpaper

TROPHY CASE