Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Thu, 27 Feb 2025 11:49:22 +0000

How to Post a Message for Support

Post From: Spreadsheet range in a formula?

[2021-06-29 16:23:53]
[Go To First Post]
owendonk - Posts: 54
Is it possible to do something like this but for 1000+ rows without manually typing it all out?
=AND(
AND(ID0.SG4@3<P3),
AND(ID0.SG4@4<P4),
AND(ID0.SG4@5<P5),
AND(ID0.SG4@6<P6),
AND(ID0.SG4@7<P7),
AND(ID0.SG4@8<P8),
AND(ID0.SG4@9<P9),
AND(ID0.SG4@10<P10),
AND(ID0.SG4@11<P11),
AND(ID0.SG4@12<P12),
AND(ID0.SG4@13<P13),
AND(ID0.SG4@14<P14),
AND(ID0.SG4@15<P15),
AND(ID0.SG4@16<P16),
AND(ID0.SG4@17<P17),
AND(ID0.SG4@18<P18),
AND(ID0.SG4@19>P19))

I need to do this to count a minimum duration of a crossover being maintained (note 19> instead of <). I have several other general uses in mind for this if possible.
Date Time Of Last Edit: 2021-06-29 16:42:16