Hi All!
I´m new with excel and I would know if someone could help me with this I would appreciate so much!:
If I had a column in cells for example
v
x
x
v
v
x
x
x
v
v
v
x
I found the way to count couple "vv" or "xx" counting the "vvv" and doing 3-1 or "vvvv" = 4-1= 3 couples presence.
Now how should I do to find "xv" and "vx" numbers of couples present in that column that is very long 1000 cells for example?
Thank You !
Gitano
Bookmarks