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:

Alan	Maria	Lisa	Tony	Fred
	GB65	GB65		GB65
	GB65	GB65	GB65	GB65
GB61	GBA4	GB61	GB65	GBA4
GB61	GBA4		GBA4	GBA4
GBA6	GBA4	GBA4		GBA4
GBA6	GBA4	GBA4	GBA4	GBA4
GBA4	GBA4	GBA4	GBA4	GBA4
GBA4	GBA4	GBA4	GBA4	GBA4
GBA6	GBA4	GBA4	GBA4	GBA4
GBD2			GBA4

<colgroup><col style="width:48pt" span="5" width="64"> </colgroup><tbody>
</tbody>

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")