View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Carl is offline
external usenet poster
 
Posts: 361
Default Counting Consecutive Instances

My data table is like this:

Date BOX
3-Jan 6.16%
4-Jan 5.87%
5-Jan 2.60%
8-Jan 5.89%
9-Jan 6.00%
10-Jan 6.00%
11-Jan 6.00%
12-Jan 2.00%


I am trying to add a ColumnC that will count the consecutive instances of
the value in ColB if it greater than or = 5%. Sort of like this:

Date BOX Count
3-Jan 6.16% 1
4-Jan 5.87% 2
5-Jan 2.60% 0
8-Jan 5.89% 1
9-Jan 6.00% 2
10-Jan 6.00% 3
11-Jan 6.00% 4
12-Jan 2.00% 0


Thank you in advance.