| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count first decimal place only
Hi, I want to count the occurence of the first decimal place only in a range
of numbers. The "COUNTIF" function in B1 will work for a whole number as shown below, but if i want the number of times .2 occurs, ignoring all other intergers and decimal places. Can I adapt this function for this? =COUNTIF(A1:A8,"4567.21") A B 1 1234.35 1 2 2345.78 3 3456.98 4 4567.21 5 5678.23 6 6543.56 7 6754.82 8 3452.45 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal Place Rounding | Excel Worksheet Functions | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| changing to two place decimal | Excel Worksheet Functions | |||
| Fixed decimal place | Setting up and Configuration of Excel | |||
Threaded Mode
