Last seen: May 22, 2025
Glad we could help. 🙂
Given that you already had three formula cells to get the parts from the split, just clear those and enter the formula into the first one. Incident...
One way would be to have two queries. The first (let's call it Query1) gets the data from the workbook, then just keeps the top 2 rows. The second ...
Yes, it finds the last match if there is more than one. I looked at the underlying XML for the worksheet.
I suspect it's a precision issue (the stored value for the yellow cell on the first sheet is actually 427.04999999999995 not 427.05). You could try: ...
Just as an alternative: =BYCOL(B1#,LAMBDA(c,SUM(B1:INDEX(c,2))))
My point was merely that the user might not actually send the email, but it would still be flagged with the created date and time. You could amend ...
As the code is written, yes, but it could easily be amended to get the path from somewhere else if it's the same for all attachments. I forgot...
Untested, obviously, but something like this: Option Explicit Sub Email_ChangeNotification() ' Sheet where email template (oft) location is...
If you create a date table, you can then use time intelligence functions. You can create a compounding measure (Compounded Percent) using: =VAR CP...
Also cross-posted here (at least):
Which release channel are you on? If it's something like semi-annual enterprise, it's probably just a feature difference.
You shouldn't need that measure actually in the chart at all.
Without rearranging the data, you can do something like: =SUMPRODUCT((XLOOKUP(A3:A17,E3:E17,F3:F17)="notebook")*B3:B17) to add up Irene's notebo...
You could create a measure called ItemsSoldNoZero with the formula: =if([Sum of Items sold]=0,blank(),[Sum of Items sold]) Then amend your ...