| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting recurring #'s in a column
I am trying to count the number of times each # within a column repeats it's
self. I am completely lost! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting recurring #'s in a column
Hi
With data in column A, enter in B1 =COUNTIF(A:A,A1) and copy down -- Regards Roger Govier "okie7392" wrote in message ... I am trying to count the number of times each # within a column repeats it's self. I am completely lost! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting recurring #'s in a column
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 On Sun, 18 Nov 2007 09:59:00 -0800, okie7392 wrote: I am trying to count the number of times each # within a column repeats it's self. I am completely lost! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recurring pattern | Excel Worksheet Functions | |||
| Counting entries in column based on condition in another column | Excel Worksheet Functions | |||
| Sum of every 6th column and recurring | Excel Worksheet Functions | |||
| Formula help for counting,with a column of dates and a column of n | Excel Worksheet Functions | |||
| recurring dates | Excel Discussion (Misc queries) | |||
Linear Mode
