Posted by: calciteko May 19, 2009
Login in to Rate this Post:
0 
? 
?
You can solve this problem entirely in EXCEL here is the formula
This should work. However I use Excel 2007 so 2003 might be little different. But I think this should work in 2003 as well.
=IF(EXACT(A1,B1),IF(EXACT(B1,C1),IF(EXACT(C1,D1),IF(EXACT(D1,E1),IF(EXACT(E1,F1),"TRUE","FALSE"),"FALSE"),"FALSE"),"FALSE"),"FALSE")
This should work. However I use Excel 2007 so 2003 might be little different. But I think this should work in 2003 as well.