Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting instances in string | Excel Discussion (Misc queries) | |||
Counting instances of text??? | Excel Worksheet Functions | |||
Counting Multiple Instances | Excel Worksheet Functions | |||
Counting instances of data across worksheets | Excel Discussion (Misc queries) | |||
Counting instances in a cell | Excel Discussion (Misc queries) |