View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lopina lopina is offline
external usenet poster
 
Posts: 15
Default Count filled cells in range if they are one after the other

Hello to all!!

I have one question if anybody can help me, in range I have to calculate how
many filled cell is they are one ater the oher.

Example:
A
AE
3 3 1 1 2 2 3 3 1 1 1 1 1 1 1 2 2 2 2 2 2


Result if possible:

2filled 6filled 7filled 6filled

If somebody understand what I meen don't fear to help.

Thanks
Best regards
Ivo