| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count Consecutive Cells
I have a simple need: I have one column of data containing either an O or
a U. Is there a way I can ask EXCEL to tell me how many times the O appeared in 2 consecutive cells, 3 consecutive cells... etc. Say I am using collumn A for this A 1 O 2 O 3 O 4 U 5 U 6 O 7 U 8 U 9 U 10 U |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN | Excel Worksheet Functions | |||
| Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Threaded Mode
