Hi All,
I have the following data
A B C D E F G H I J K L M N O P
D A A D D D
D D D D D D D D
D A
D D D D D D D D D A
I have to compare the value in column A with the rest of the columns in the same row. If any of the values from B to K is different than the value in A, then I have to display "Incon" in result. If all the values from B to K is same as that in A, then I have to display "Con" in result. I am testing out the following formula =IF(OR(C1<>D1:F1),"Incon","Con") but when there are spaces in some columns the formula is not working. Can we dynamically set the range (end point) so that my formula won't compare the value in A with spaces?
Thanks
Luke.
Bookmarks