Hi,
I have attached a workbook with an example to explain more clearly.
Basically I have 4 ranges each of 6 columns and all in 1 row (i.e. 24 consecutive columns).
I would like to compare the 6 titles in range 1 to the titles in the other 3 ranges.
For Range 1 versus 2 I used the formula =IF(0=SUM(IF(OFFSET(B7,0,0,1,6)=OFFSET(B7,0,6,1,6),0,1)),"OK","Check") which works fine.
Similarly for range 1 versus 2 and then range 1 versus 3 i used =IF(0=SUM(IF(OFFSET(B7,0,0,1,6)=OFFSET(B7,0,12,1,6),0,1)),"OK","Check") and =IF(0=SUM(IF(OFFSET(B7,0,0,1,6)=OFFSET(B7,0,18,1,6),0,1)),"OK","Check") which also works fine.
I then tried to compare range 1 versus range 2, range 3 and range 4 in one formula as follows, but this failed.
=IF(0=SUM(IF(OFFSET(B7,0,0,1,6)=OFFSET(B7:G7,0,N(ROW(A1:A3)*6),1,6),0,1)),"OK","Check")
Any help is much appreciated, thanks John
Bookmarks