Thread: number of times consective data occurs in a range of cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Thanks a lot Ralph. it worked. Thanks a lot Ralph. it worked. is offline
external usenet poster
  
Posts: 5
Default number of times consective data occurs in a range of cells
I have a thirty day worksheet with numbers entered each day form .1 to .99.
Is there any way to calulate how many times .25 was entered two days in a row.
example .25 .25 .10 .87 .25 .98 .25 .25 , in this case it would be two
times.
Reply With QuoteReply With Quote