amitcohen
Board Regular
- Joined
- Jan 14, 2010
- Messages
- 118
Hi Guys
I have a row that contains the following cells
(First cell is 'A1', last cell is 'AB1')
Need to find a way to:
1. Formula that will tell me how many 'X' groups I have in the range, (In this case it's 3) and the sizes of groups (5, 10, 6)
2. Formula that tells me how many 'Z' groups (In this case it's 2) and the sizes of groups (3, 4)
Hope you can give me directions..
Many thanks,
Amit
I have a row that contains the following cells
(First cell is 'A1', last cell is 'AB1')
Code:
[B][COLOR=#008000]X X X X X [/COLOR][/B][COLOR=#ff0000]Z Z Z[/COLOR] [COLOR=#008000][B]X X X X X X X X X X[/B][/COLOR] [COLOR=#ff0000]Z Z Z Z[/COLOR] [B][COLOR=#008000]X X X X X X[/COLOR][/B]
Need to find a way to:
1. Formula that will tell me how many 'X' groups I have in the range, (In this case it's 3) and the sizes of groups (5, 10, 6)
2. Formula that tells me how many 'Z' groups (In this case it's 2) and the sizes of groups (3, 4)
Hope you can give me directions..
Many thanks,
Amit