1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Need filter function to return blank if blank and 0 if 0

I have a formula to retrieve the value in a **unique** cell via filter. `=filter(range, condition*condition*condition)`. However, sometimes I am filtering to older data from before this particular point was collected and the records are blanks. This is currently showing as 0 when retrieved and the preferred behavior is showing NA(). Changing all retrieved 0s will not work, as some of the real data has actual zeroes. It needs to remain numbers, so adding &"" after the range will not work. I have also tried `=if(isblank(filter()),na(),filter())`, and it still returned 0. Manually changing the source data is not an option, as the input data is about 25k rows that change daily, copied in from a SQL query.

submitted by /u/sauron3579
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#real-time data collaboration
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#AI formula generation techniques
#Excel compatibility
#real-time collaboration
#formula generator
#Excel alternatives
#filter
#range
#condition
Need filter function to return blank if blank and 0 if 0