Forum Discussion
Errors / Omissions in All Functions Listing
I have completed my review of the All Functions listing at support.microsoft.com In total, I have 349 reports of errors/omissions/inadequacies. Of the 492 functions in my records some 'star' more...
Some use cases where one might need a blank rather than "" as a formula result include preparation of data for charts, sparklines, pivottables or databases. I suspect Power Query may be a better choice in general for data manipulation of this kind - though my level is insufficient to say
I see, thank you. Yes, that could work.
As for the Power Query in general, my position if something could be done by formulas it's better to with them. Power Query and PivotTable require refresh, that's the main limitation. However, they are quite powerful even if Excel has "limited edition" of data modelling tools (e.g. compare PQ Excel and PQ Online, etc).