Hi Phil, With the advancements in tools like Office Scripts and Power Automate vis a vis Excel, do you anticipate coverage of these topics in the f...
Hi Riny, The file in question has lots of tabs and lots of sensitive information. I don't know an easy way to share the file without compromising t...
Riny, Your solution works superbly!! I can't tell you how much I appreciate the effort and your patience with me. Kind regards, Tom
Riny, you're a gem for bearing with me! I may have messed up your queries, as my results are not retaining the annotations when I add new data to tDat...
Riny, Thanks again for helping me with this and for being patient with my modest PQ skills! The Updated Data worksheet reflects the following:...
Thanks so much Riny! I'll take a look and let you know. Very much appreciated.
Thank you, Riny! A sample file is attached. You can ignore the TK Test and Current worksheets. The relevant worksheets are Current Data, New Data, a...
Thank you, Mynda and Velouria. Using INDEX for the lookup and return array arguments works like a champ and seems a little easier. On a related n...
Who knew? Thanks, Mynda. You nailed it. Cells referenced in the formula have column headers that have Wrap Text applied, and the break is precisely...
Thanks for the feedback Riny. I'm still a bit confused. Here is an example: =XLOOKUP(B8,tMthlyRev[Month and Year],tMthlyRev[Trailing 3-Month Aver...