•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Do not understand where to put nested =IF function to return "" if the value is 0.
I am attempting to get a sorted list of dates from 2 separate sheets that will be added to (why it's A2:A100000). I don't want nearly 200,000 zeros in this list. Can I use =IF or another, more slick function to do so?
My current function:
=SORT(VSTACK('CLIENT A'!A2:A100000,'CLIENT B'!A2:A100000))
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#google sheets
#Excel alternatives for data analysis
#Excel alternatives
#nested IF
#Excel
#SORT function
#VSTACK
#funnel function
#data sorting
#sorted list
#sheets
#zero values
#Excel functions
#removing zeros
#Client A
#Client B
#data management
#data aggregation