LinkBack URL
About LinkBacks
Hello
I have an attachment..
In Range A2:AE2 there are symbols ..
I want to count the cells before and after the symbol "X"
The result in the attachment should be = 7 in AF2
Hello
I have an attachment..
In Range A2:AE2 there are symbols ..
I want to count the cells before and after the symbol "X"
The result in the attachment should be = 7 in AF2
Maybe:Formula:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I tried your formulaOriginally Posted by TMS
But when change the combination I got incorrect results
see the attachment the result should be 6 not 7
By my reckoning, 7 is correct. If you have x y x, then the y would be counted twice.
That was the rule you specified.
Regards, TMS
We will consider this status (x y x) to be counted one as it is one cell not two cells
Can it be done by code?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks