How to find frequency of lottery numbers in Microsoft Excel

[Aarti C]

I have downloaded the array of previous week's winning lottery numbers, and I want Excel to create a number frequency chart for me. The numbers are 1 to 59. I want to calculate a histogram of the frequencies of each number from 1 to 59. So far, I set up Excel so that the results of the previous lottery games are in 5 columns. A1:A100, B1:B100, C1:C100, D1: 100, E1:E100. I then entered the numbers 1 through 59 into K1:K59. I tried to use the Frequency function, which seems to calculate the frequencies as expected, but I don't know where to find the resulting array of frequencies. Any help would be most appreciated

[GALIENA]

If you seem to be seeking counting each number that appears in the range A1:E100, then in L1 enter the formula:

=COUNTIF($A$1:$E$100,K1)

Copy the formula down to K59.