Last seen: May 22, 2025
Here's one way to do it: =LET(data,A1#,MAKEARRAY(ROWS(data)-1,COLUMNS(data),LAMBDA(r,c,INDEX(data,r,c)=INDEX(data,r+1,c))))
As far as I know, if you use 0 for the number of days, it simply returns the start date, ignoring other settings. It's up to you to ensure that the st...
If it worked before and now it doesn't, the most likely cause would be an update (windows or Office or Power BI, depending on what you are using this ...
You could use something like: =LET(counts,SEARCH(names,A2),TEXTJOIN(",",TRUE,CHOOSECOLS(SORT(FILTER(HSTACK(names,counts),ISNUMBER(counts)),2),1)))
You could try something like this: Sub GetApprovedNames() Dim GivenNamesRange As Range Set GivenNamesRange = Range("G3:G" & Cells(Rows.Cou...
I can't access your file for some reason but, if there is no finish date, how do you calculate the total duration to work out a percentage?
Insert a class module, rename it BankAccount and then paste in this part of the code: Public AccountNumber As Long Public Balance A...
If you have TEXTSPLIT available to you, you can use: =Sum(Sumifs( Sumrange, Criteria Range1, 2022, Criteria Range2, TEXTSPLIT(some cell, ","))...
Apologies - it was not my intention to make you feel bad. I just wanted to point out that there are generally limits to what you'll get from a forum.
You could do something like this?
This is getting close to consultancy work (which I don't do any more) rather than forum Q&A... I can't test this as I don't use shared mai...
Is the signature part of the template? Do you need the code to send one email per person, or simply start a new email for each 500 (or so) add...
The first message is quite normal - you just need to say Yes and check the box to not ask again. (the code is not saving the files so there will be no...
Using a template actually fixes the first error (you hadn't defined olMailItem) too: Option Explicit Sub SendEmailList() On Error GoTo ErrHandl...
Yes, it looks like the forum software stripped out any occurrences of a 'less than' symbol followed by a 'more than' symbol (presumably treated it as ...