Hi, I am creating a spreadsheet and in the spreadsheet I need cell C1 to return the value "Yes" if A1:A5 has the same value as B1:B5 else return "No". I have tried the following formula in C1 with no joy =IF(AND(A5:A5=B5:B5), "Yes", "No")
Please help!
Bookmarks