Login Page - Create Account

Support Board


Date/Time: Fri, 27 Dec 2024 18:09:09 +0000



Post From: Formula help

[2016-03-08 00:20:05]
Sawtooth - Posts: 4143
This is comparing the same cell to itself, because the offset is 4 rows from row 3 on both sides of > :
=OFFSET(ID2.SG1@3,4,0)>OFFSET(ID2.SG1@3,4,0)

=ID2.SG1@3>ID2.SG1@4 would compare the cell prior to its subsequent.