Status update: Sadly, I've not been able to get a hold of Chandoo or anyone who can actually implement the change to the forums. Continuing to try and reach out. Maybe they're on travel? :(
Sorry pecoflyer, but I have been researching and trying to see if that's an option with our current platform. I can see and we've discussed porting to a different forum platform, but so far that is being considered a larger undertaking than we want to do for just a "quality of life" improvement...
Hello everyone. Sorry for not seeing this until today; long weekend for me. I agree that conveying what version of Excel someone is using is a key piece of information. With the current forum tools available, there's certainly nothing stopping us from including that info in a signature. You...
Edit: Typo
Sub SendEmails()
Dim lastRow As Long
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Dim i As Long
Set OutApp = CreateObject("Outlook.Application")
'How much data is there?
lastRow = Cells(Rows.Count, "A").End(xlUp).Row...
@grcshekar
You have cross-posted again to another forum w/o providing links: XIRR modification to ignore some columns (excelforum.com)
As you've already been previously warned in this thread about this, and continued to break the rules, this thread will be closed. Please remember to follow...
Address and MATCH function tell the formula to look in G9. Then you told it to offset 2 rows in the first OFFSET function, landing you on G11. Then you told the outer OFFSET to go down 1 row and over 2 columns, landing you in I12, which is a blank cell. Thus, the value is 0.
Overall, this is a...
Calculate duration, and then do a stacked bar chart using Start time and duration. Format the Start time series so that the duration bars appear to be floating.
With your example data, I'm assuming Branch was supposed to go from 11 am to 1 pm (you had till 1 am).
The processes don't appear to...
Per forum rules, remember to include you crosspost links:
https://www.excelforum.com/excel-formulas-and-functions/1378105-looking-up-multiple-values-based-on-date-and-category.html#post5675517
https://www.mrexcel.com/board/thread...egory.1205058/
Hi Pasadu,
If there's a specific forum member you'd wish to donate to, several have links in their signature, or the Excel Ninjas (volunteer forum mods) have links here: https://chandoo.org/forum/threads/donate-support-our-ninjas.18150/
If you wish to support Chandoo directly, his contact info...