Support Board
Date/Time: Mon, 27 Jan 2025 05:20:21 +0000
Post From: Formula
| [2019-02-17 14:56:59] |
| Sawtooth - Posts: 4162 |
|
Try this in a Formula Column, e.g. in L3: =IF(K3<>0,K3,L4) This works in a static cell, e.g. H3, but you must first use a Formula Column to create a boolean TRUE: L3: =K3<>0 H3: =INDEX(K3:K100,MATCH(1,L3:L100,0),1) Or this in a Formula Column, e.g. M3: L3: =K3<>0 M3: =INDEX(K3:K100,MATCH(1,L3:L100,0),1) Date Time Of Last Edit: 2019-02-18 22:50:51
|