I need a formula to compare three cells in three columns, if 2 of the cells have the same value then I would like a cell in the fourth column to register a value of 1.
Such as; cell A1 = 7, A2 = 5, A3 =7 then A4 would register a 1. If none of values agree then cell A4 would register a 0.
Thanks you for any help you can offer.
Bookmarks