ExcelAnalytics<p>For <a href="https://mastodon.world/tags/ICAEW" class="mention hashtag" rel="tag">#<span>ICAEW</span></a> members, my tips on the tricks needed to get some <a href="https://mastodon.world/tags/Excel" class="mention hashtag" rel="tag">#<span>Excel</span></a> functions to handle arrays and ranges and return arrays, is live on the <a href="https://mastodon.world/tags/ICAEW_Excel" class="mention hashtag" rel="tag">#<span>ICAEW_Excel</span></a> page. Requires member login.<br /><a href="https://www.icaew.com/technical/technology/excel-community/excel-community-articles/2023/excel-tips-and-tricks-467" target="_blank" rel="nofollow noopener noreferrer" translate="no"><span class="invisible">https://www.</span><span class="ellipsis">icaew.com/technical/technology</span><span class="invisible">/excel-community/excel-community-articles/2023/excel-tips-and-tricks-467</span></a></p><p>Excel Tips &amp; Tricks #467 - Excel functions that are harder to get to return arrays or ranges<br />Such as AND, OR, and date functions like EOMONTH.</p><p><a href="https://mastodon.world/tags/msexcel" class="mention hashtag" rel="tag">#<span>msexcel</span></a> <a href="https://mastodon.world/tags/functions" class="mention hashtag" rel="tag">#<span>functions</span></a> <a href="https://mastodon.world/tags/tips" class="mention hashtag" rel="tag">#<span>tips</span></a> <a href="https://mastodon.world/tags/tricks" class="mention hashtag" rel="tag">#<span>tricks</span></a> <a href="https://mastodon.world/tags/workarounds" class="mention hashtag" rel="tag">#<span>workarounds</span></a> <a href="https://mastodon.world/tags/dynamic" class="mention hashtag" rel="tag">#<span>dynamic</span></a> <a href="https://mastodon.world/tags/arrays" class="mention hashtag" rel="tag">#<span>arrays</span></a></p>