Forum Discussion
Please I need your help
=FILTER('Database Setup'!B11:E183, ('Database Setup'!C11:C183 = $C$3) * ('Database Setup'!E11:E183 >0), "")
I have this formula but it show me all the value including the value =0, but I need just the value greater than 0.
Please help me with this and thank you
.
It should work as you've written it. Is it possible that the values in column E are text rather than actual numerical values?
It would be easier to give a more complete response if you'd be so kind as to post your actual spreadsheet. An image can't be actually worked with. You may be able to attach the file--drag and drop it into the area below the message area--or certainly you can post on OneDrive or GoogleDrive with a link pasted here that grants access.
- thank you for your help
