Support Board

Date/Time: Mon, 03 Nov 2025 15:04:48 +0000

Post From: Crossover For Multiple values - spreadsheet

[2021-11-12 15:26:04] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4285
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) )