Input the formula: =FREQUENCY(B2:B6,C2:C6). Press Enter to get the result. Referenced from Excel Help