Forum

Hi Shawn, Looks like each company is using a different way to calculate turnover. Here is one of them: In the attached file, I added 2 me...

Hi Martyn, tried the Quartile excel function? =QUARTILE(Range, Quart)

Hi Ricardo, There is no attachment, you have to press Start Upload after you select the files. Try adding a new column using this function: ...

Hi Mohammed, An invoicing system is not easy to build, most probably you will need to do a lot of vba coding to add all the functionalities you nee...

Hi Shawn, Is there a reason why you want the trailing 12 months in a column? This is usually done as a measure, based on a calendar table:

Same advice: please try on a finances forum, looks like there is no expert in finances that can help answering your question.

Sorry, finances is not my main field of expertise and I assume this is why you did not get an answer yet. I suggest asking this question on a dedic...

Hi Vijay, When Microsoft built that function they most probably did that in a team with a deep finances knowledge. Your question looks more like...

Hi Paul, Are you sure VBA is the one for this task? Power Automate looks more appropriate for this, it has the tools to monitor sharepoint to se...

Hi Bill, Try to change the msg declaration: Dim msg as Object instead of MailItem. Or, use: Sub GetMsgDetails() Dim MyOutlook As Outlook.Appl...

Hi Paul, The Data Form is not customizable unfortunately.

Hi Derek, If you select the cell A7 where STOCKHISTORY formula is, it will highlight the SPILL range A7:F24. This range should not have any other con...

Hi Nawaf, What's the expected result? None of your sample records is matching the criteria. Also, if for example there are 5 clinics other than ER, ...

Hi Jerry, The video you shared is for getting data from public sheets, they are shared with anyone with the link, sign in is not necessary. Lea's sh...

Hi FS, The second table should have a single record for the keys used for merging. If 2 or more rows from the second table are matching the merge cr...