I created this function to show you exactly what I need. I know if I plug it
in it will return a #VALUE# error. I tried to create it without the OR()
function but it is too long for Excel.
Is there a more simple way to write this?
Sheet1:
A B C D E F G H I J K
1
2 2 8 8 8 8 should show 88
3 1 0 5 9 5 1 should show 15
4 8 3 4 5 2 4 should show ""


=IF(OR(CONCATENATE(C2,D2),CONCATENATE(C2,E2),CONCA TENATE(D2,C2),CONCATENATE(D2,E2),CONCATENATE(E2,C2 ),CONCATENATE(E2,D2))=OR(CONCATENATE(I2,J2),CONCAT ENATE(I2,K2)*CONCATENATE(J2,I2),CONCATENATE(J2,K2) ,CONCATENATE(K2,I2),CONCATENATE(K2,J2)),I2,"")

Thank you for your time
Luke