Forum Discussion
David Cockerham
Dec 13, 2024Copper Contributor
Need help on a formula please!
I am using this formula - =FILTER(A2:A48,E2:E48>=1,"NODATA") - in order to display the contents of a cell in one column when the number 1 appears in a cell in another column. Can anyone please tell ...
Harun24HR
Dec 17, 2024Bronze Contributor
Use cell reference instead of constant number-
=FILTER(A2:A48,E2:E48>=A1,"NODATA")