Learn Frequency Excel formula

FREQUENCY 2

This example shows how the =FREQUENCY() function has been used to calculate
how often certain numbers appear in the Lottery results.

Table 1 is a record of all the results from the past seven weeks.

Table 2 is the list of possible number from 1 to 49, and how many appearances
each number has made during the past seven weeks.