Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 21 Mar 2026 00:42:03 +0000

How to Post a Message for Support

Post From: Crossover For Multiple values - spreadsheet

[2021-11-12 15:26:04]
[Go To First Post]
Sawtooth - Posts: 4318
You must use ranges:

=OR(
CROSSOVER(AF3:AF4, AG3:AG4),
CROSSOVER(AF3:AF4, AH3:AH4),
CROSSOVER(AF3:AF4, AI3:AI4),
CROSSOVER(AF3:AF4, AJ3:AJ4),
CROSSOVER(AF3:AF4, AK3:AK4),
CROSSOVER(AF3:AF4, AL3:AL4)
)