Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 30 Apr 2024 15:07:20 +0000
Post From: Formula
| [2019-02-17 14:56:59] |
| Sawtooth - Posts: 3985 |
|
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
|