•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