Quote Originally Posted by Pepe Le Mokko View Post
Sorry I don't have more time, but I suggest you have a look at the FREQUENCY function
thanks!! that helped a lot. but i dont get how to make excel find the temperatures. now i have to put in manually but all the sheets have different max and minimums. but i kinda expected excel to find the range.thanks anyways