Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i want to count the (common denominator in a cell range a.k.a (which number
appears the most") in F6 to F200 contain formulas as described below giving me a value from another cell. ex" #4" ex: (=e6) which gives me "4" from "E6" (=e7 ) which gives me "5" from "E7" (=e8) wich gives me "5" from "e8" to row 200 Some cells "give me "#value!" In G1 i tried this formula but it does not work since it cant count the cells with "values" =mode(F6:F200) How can i use the same formula but also to ignore "value" errors and to finally give me the comon denominator. Which from the above examle number 5 appears the most. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I alphabetize data excluding words like "a" and "the"? | Excel Discussion (Misc queries) | |||
EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
How to create a scatter chart with 2 "X" values with common "Y"s | Charts and Charting in Excel | |||
Count(if(A3:A200)="100000" if (B3:B200="Y") and (C3:C200=Z))) | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |