G Guest Nov 18, 2007 #1 I am trying to count the number of times each # within a column repeats it's self. I am completely lost!
I am trying to count the number of times each # within a column repeats it's self. I am completely lost!
G Gord Dibben Nov 18, 2007 #3 If you know the unique numbers you can use the FREQUENCY function. Say you have the numbers 1 through 9 multiple times randomly in A1:A50 In B1:B9 enter numbers 1 to 9 Select C1:C9 In C1 enter =FREQUENCY(A1:A50,B1:B9) then hit CTRL + SHIFT + ENTER Gord Dibben MS Excel MVP
If you know the unique numbers you can use the FREQUENCY function. Say you have the numbers 1 through 9 multiple times randomly in A1:A50 In B1:B9 enter numbers 1 to 9 Select C1:C9 In C1 enter =FREQUENCY(A1:A50,B1:B9) then hit CTRL + SHIFT + ENTER Gord Dibben MS Excel MVP
