Recent Blog ArticlesMost RecentMost LikesRe: Announcing STOCKHISTORY Check the format for the date you are supplying to the function. I believe you have the day and month switch around. If I'm not mistaken your formula is returning the exchange rate as on 11 April 202...Re: New aggregation functions: GROUPBY and PIVOTBY Thanks for the update. I hope you enjoy using it. Re: New aggregation functions: GROUPBY and PIVOTBY jpspiegsWe shifted to flighting to 100% of users in the current channel today. Because it's so recent you may have to wait a day or two to get the latest flight, restarting Excel may help too. Re: New aggregation functions: GROUPBY and PIVOTBY A quick update: These functions have graduated from beta and are now available to all users in the Current Channel. New aggregation functions: GROUPBY and PIVOTBY The new GROUPBY and PIVOTBY functions allow you to perform data aggregations using just a formula. Re: New aggregation functions: GROUPBY and PIVOTBY Yes we've begun flighting to some users in the CC ring. We are not generally available just yet, but it won't be long. 🙂 Announcing TRIMRANGE and accompanying trim references We are excited to announce a new function, TRIMRANGE, and a set of new reference operators. Re: Announcing New Text and Array Functions We just announced REGEX functions in Excel. I'd been itching to reply to this thread all week 🙂 https://www.linkedin.com/posts/josephmcdaid_regextest-regexextract-regexreplace-activity-7198421...Re: New aggregation functions: GROUPBY and PIVOTBY Well spotted, there will be another change coming out to GROUPBY's signature in the next two or so weeks. We are in the process of finalizing the signatures based on user feedback. Re: New aggregation functions: GROUPBY and PIVOTBY Saliou330PERCENTOF has been translated toPOURCENTAGE.DE in French. The translations may still be making their way out. Let me know if you see it.