How to determine if multiple cells contain identical text but ignore the blanks?

[Revitigs]

I have data which identifies the initials of a user across a period of 5 weeks. See attached.
I need to identify if the same user was present for each row, but I have some weeks which are blank that I wan't ignored.
If I use the A2=B2=C2=D2=E2 simple formula, then the blanks will return a FALSE, when really it should return a TRUE.

I've searched through many more complex formulas but haven't found anything.
I'm assuming there's a simple solution I just don't see.

[Pete_UK]

Put this in G2:

=IF(COUNTIF(A2:E2,A2)+COUNTIF(A2:E2,"")=5,"yes","no")

then copy down.

Hope this helps.

Pete

[Revitigs]

Thanks, Pete.
One question - the report now has columns inserted in between the weeks, with a date (not signifant data for my requested result). Now I notice the formula does not work. Any suggestions?
Shall I attach a new example?

[Revitigs]

If anyone has any ideas, I'm attaching a revised sample data set for additional clarification.

Many thanks!!

[Pete_UK]

Use this instead in L2:

=IF(SUMPRODUCT(((C2:I2=$A2)+(C2:I2=""))*(MOD(COLUMN(C2:I2),2)=1))>=4,"yes","no")

Hope this helps.

Pete

[newdoverman]

I think that want you need is something like this:

Please Login or Register  to view this content.

[Revitigs]

Thanks very much Pete and newdoverman!
The mystery is solved!!