Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Col A Col B ColC Col D Col E Col F Col G
Col H Row1 . . . x . . 3 Row2 x x . x . . 2 Row3 . . . . . 5 Row4 . . H x x 3 Ineed to find a formula that will count the maximum number of times "." and/or "H" appears in a row. In the above example Column H gives me the results I'm looking for. Sometimes the cells included in the range will be blank. I need the formula to ignore blank cells. thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count consecutive cells then start over | Excel Worksheet Functions | |||
How can I count values in multiple non-consecutive cells? | Excel Worksheet Functions | |||
count text in non consecutive cells in column | Excel Discussion (Misc queries) | |||
count text in non consecutive cells in column | Excel Discussion (Misc queries) | |||
Count Consecutive Cells | Excel Discussion (Misc queries) |