bobs

Hi . I am wanting a formula that will count the number of consecutive sames values in a column that are together but not all of them in the column. I have 365 rows and i want to be able to insert the formula in B1 and drag down to B365 so that the Value in B wil update as and when A changes...

So this seems it should be simple but i cant get it. I want to remove all non alpha charectors from a spreadsheet but not the spaces, which is where i am getting issues. So if I had [ "bob's Number*1 ten." ] the results would be [ bobs number1 ten ]. Any ideas? Thanks.

I have a file and am looking in column E and G. If Column E="Bob's" and column G="1234", I'd like a message to pop up stating "abc". How do I write this. I have the code below, but that only looks at individual columns. Sub Bob's() If Range("E3:E30").Value = "Bob's" Then MsgBox "If this Bob's...