Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 08 Aug 2026 14:35:04 +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: 4343
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)
)