Alphacsulb
Active Member
- Joined
- Mar 20, 2008
- Messages
- 414
Hello,
Not sure if this would be a formula, but I'm looking to count how many "X" cells are found starting at column A before you reach a cell that equals "B".
Desired outcome:
Row 9: 3
Row 12: 4
Row 15: 5
Any leads would be appreciated.
Not sure if this would be a formula, but I'm looking to count how many "X" cells are found starting at column A before you reach a cell that equals "B".
Desired outcome:
Row 9: 3
Row 12: 4
Row 15: 5
Any leads would be appreciated.
HTML:
Excel 2010ABCDEFGHIJKLMNOPQRSTU912640100304XXXBXX12252315,4606005,400169XXXXBXX1532171022,630220022,410700XXXXXBXX[CENTER][COLOR=#161120][B]Master[/B][/COLOR][/CENTER]