I have a thousand random numbers generated between -100 and 100 and want to count the number of occurences of each integer. I know i can use the COUNTIF function, but for so many numbers it takes way too long. Is there a way to create a loop in excel that can do this or will i just have to use ranges (eg. occurences between 0 and 10). For the accuracy i want to count each number individually.