•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Empty cells displaying zeros
I work for a hospital and I’m trying to produce a report that pulls specific data from a log to a new sheet. I’m using this formula and it is working,
=FILTER( Data Log'!B1: R1544, (Data Log' !E1: E1544-B4) *("Data Log' |F1: F1544-C4)+("Data Log' !F1:F1544-D4))
What I’m trying to do now is not have it show zeros in all the empty cells. Any suggestions?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#Excel compatibility
#FILTER
#hospital
#data
#log
#report
#formula
#empty cells
#specific data
#sheet
#Excel