Then use the two OR functions for CF:
A B C D E F G 1 Item 1 Item 2 1 2 3 2 A1 B1 A 3 A2 a2 a 4 A3 a3 B 5 B2 b
=OR(EXACT($A8 & B$7, $A$2:$A$5))
=OR(EXACT($A8 & B$7, $B$2:$B$5))
Then use the two OR functions for CF:
A B C D E F G 1 Item 1 Item 2 1 2 3 2 A1 B1 A 3 A2 a2 a 4 A3 a3 B 5 B2 b
=OR(EXACT($A8 & B$7, $A$2:$A$5))
=OR(EXACT($A8 & B$7, $B$2:$B$5))
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks