View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kieran Kieran is offline
external usenet poster
 
Posts: 4
Default Count max consecutive cells

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