Try this array formula**.

=MAX(FREQUENCY(IF(ISNUMBER(MATCH(A1:H1,{".","H"},0 )),COLUMN(A1:H1)),IF(ISNA(MATCH(A1:H1,{".","H"},0) ),IF(A1:H1<"",COLUMN(A1:H1)))))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Kieran" wrote in message
...
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