| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Consecutive Cells
I have used various formulas on this site to count consecutive occurences
fora piece of data, but to no avail. Can someone please help? In column "I" I have a bunch of O's and U's. I want to be able to count how many times O appreared 3 consecutive times, 4 consecutive times etc.. up to 10. My column run down to 162 on some pages and less on others, if this matters? Also is there a way to do a check based on a hiearchy of variables? -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Consecutive Cells | Excel Discussion (Misc queries) | |||
| Consecutive cells | Excel Worksheet Functions | |||
| copy every 30th cell in the column into consecutive cells in anoth | Excel Worksheet Functions | |||
| How do I set up a formula to repat 5 consecutive cells in a colum. | Excel Worksheet Functions | |||
| How do I set up a formula to repeat 5 consecutive cells in a colum | Excel Worksheet Functions | |||
Threaded Mode
