Formula to compare cell range for a match but ignore blanks

[OfficeUser]

I have data in cells A2:A12 that I want to ensure they have the same data. I was using some of the solutions here but when a blank cell was introduced it returned a false value which I am trying to avoid

http://www.mrexcel.com/forum/excel-questions/89780-verify-multiple-cells-have-same-value.html

 

[Joe4]

Please post the formulas from that post that you tried (as you have written it for your data). Maybe we can spot the issue with them.
Also, when you say "blank cell", do you mean that the cell is really blank, or there might be something like a space in it?

 

[OfficeUser]

I just figured it out, though I was certain I tried the formula yesterday. Oh well, I will take it. I was working on a follow-up to your instructions and question but then solved it. Thanks!!