| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Consecutive Cells
This works great: In Cell G2: =MATCH("Off",A4:E4,0)-1
ColA ColB ColC ColD ColE ColG Apples Apples Off Apples Off 2 Bannanas Bannanas Bannanas Bannanas Off 4 Coyotes Coyotes Coyotes Off Off 3 Elephants Elephants Elephants Elephants Off 4 Now someone please tell me what formula would work in ColG in the set below, with ColG referencing ColA? If possible? ColA ColB ColC ColD ColE ColG Apples Off Coyotes Apples Off 2 Bannanas Apples Elephants Bannanas Off 1 Coyotes Coyotes Off Off Off 3 Elephants Elephants Off Elephants Off 4 just curious if this is possible... thanks.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for counting number of cells | Excel Discussion (Misc queries) | |||
| Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions | |||
| Counting cells with same info in them | Excel Discussion (Misc queries) | |||
| Count Consecutive Cells | Excel Discussion (Misc queries) | |||
| counting cells with conditional formatting applied | Excel Discussion (Misc queries) | |||
Threaded Mode
