Checking the if the values in the row are the same, provided they are not empty

[guhaseelan]

Hi,

Thanks in advance for your help.

I have:

[TABLE="width: 320"]
<colgroup><col style="width:48pt" span="5" width="64"> </colgroup><tbody>[TR]
[TD="class: xl948, width: 64"]Alan
[/TD]
[TD="class: xl948, width: 64"]Maria[/TD]
[TD="class: xl948, width: 64"]Lisa[/TD]
[TD="class: xl948, width: 64"]Tony[/TD]
[TD="class: xl948, width: 64"]Fred
[/TD]
[/TR]
[TR]
[TD="class: xl947"] [/TD]
[TD="class: xl947"]GB65[/TD]
[TD="class: xl947"]GB65[/TD]
[TD="class: xl947"] [/TD]
[TD="class: xl947"]GB65[/TD]
[/TR]
[TR]
[TD="class: xl947"] [/TD]
[TD="class: xl947"]GB65[/TD]
[TD="class: xl947"]GB65[/TD]
[TD="class: xl947"]GB65[/TD]
[TD="class: xl947"]GB65[/TD]
[/TR]
[TR]
[TD="class: xl947"]GB61[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GB61[/TD]
[TD="class: xl947"]GB65[/TD]
[TD="class: xl947"]GBA4[/TD]
[/TR]
[TR]
[TD="class: xl947"]GB61[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"] [/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[/TR]
[TR]
[TD="class: xl947"]GBA6[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"] [/TD]
[TD="class: xl947"]GBA4[/TD]
[/TR]
[TR]
[TD="class: xl947"]GBA6[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[/TR]
[TR]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[/TR]
[TR]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[/TR]
[TR]
[TD="class: xl947"]GBA6[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"]GBA4[/TD]
[/TR]
[TR]
[TD="class: xl947"]GBD2[/TD]
[TD="class: xl947"] [/TD]
[TD="class: xl947"] [/TD]
[TD="class: xl947"]GBA4[/TD]
[TD="class: xl947"] [/TD]
[/TR]
</tbody>[/TABLE]
Problem: After the Fred column i need a formula to identify if the values provided by the people are the same. But the problem is that not every one has to provide a value. so when checking if they are the same the blank values are ingnored. As an example the first row of values is the "same", second row of values is "same" but the third row of values is "not the same".

thanks again.

 

[VBA Geek]

with your table in A1:E11, try in F2

=IF(COUNTIF(A2:E2,LOOKUP(REPT("Z",255),A2:E2))=COUNTA(A2:E2),"same","not same")