Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Number Counting
This is probably something simple, but I can't figure it out.
I have columns with two digit numbers (00 thru 99). I want to write a formula that looks at this column and if any number is repeated, total the number of times it's repeated. Thanks so much for the help!! |
#2
|
|||
|
|||
=countif(data-range,comparison-value)
"DNA" wrote: This is probably something simple, but I can't figure it out. I have columns with two digit numbers (00 thru 99). I want to write a formula that looks at this column and if any number is repeated, total the number of times it's repeated. Thanks so much for the help!! |
#3
|
|||
|
|||
Thanks, how would you key for the "comparison-value" section of the
formula? |
#4
|
|||
|
|||
you could potentially just put the equation into the cell next to the main
data for example if your column were column A (Rows 1 to 400) in B1 enter =countif($A$1:$A$400,A1) and copy down to B400 or you could put the numbers 00 to 99 in D1:D100 and put in E1 =countif($A$1:$A$400,D1) and copy down to E100 or if you are only interested in one or two numbers just enter =countif($A$1:$A$400,"=45") checkout the Countif function description in Help. It really depends on what you need. "DNA" wrote: Thanks, how would you key for the "comparison-value" section of the formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting the number of letters in a cell | Excel Discussion (Misc queries) | |||
Counting the number of checkboxes on a spreadsheet | Excel Worksheet Functions | |||
Counting the number cells between two dates | Excel Discussion (Misc queries) | |||
Counting the number of times a word appears in a worksheet | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |