Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi i have a spreadsheet that has a column of different ages e.g
12.1 12.3 12.2 15.6 47.3 33.6 12.1 15.6 12.2 i need to be able to count the number of 12.1 there are in this column. One of the problems i have is that the data comes for a query that is created in Access so in the formula bar the cell contents look like 21.1663244353183, if i use roundup it then changes the contents. Can anyone help with a formula please. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
counting if | Excel Worksheet Functions | |||
I need help has to do with counting | Excel Discussion (Misc queries) | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |