Search results

=SUMIF(C:C, "total", A:A) + SUMIF(C:C, "total", B:B)

Sure, let me know in case if you encounter any challenges

Try updating that line in your code and see if the error persists. ThisWorkbook.SaveAs fileName:=path & fileName, FileFormat:=xlOpenXMLWorkbookMacroEnabled

Helli Yash I have started working on gradient descent in VBA to get solution for your problem..let me know... but for sure will take some time..

Unable to op3n your excel file... To add filters in the top of a pivot table, you can follow these steps: 1. Click anywhere inside the pivot table to select it. 2. Go to the "PivotTable Analyze" or "Options" tab on the Excel ribbon. 3. In the "Filter" group, click on the "Insert Slicer"...

As an example =SUMIF(A:A, "total", B:B)

Having gone through your entir code and problem statment. It seems like you're working on calculating various portfolio metrics and covariance matrices using VBA. To optimize weights without Solver, you can implement optimization algorithms like gradient descent or genetic algorithms. These...

Hmmmm...Strange..lets try with modified code with some additional error handling: Sub MultipleRegressionAnalysis() Dim ws As Worksheet Dim rngY As Range, rngX As Range Dim lr As Long ' Set worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your...

Hi Based on your requirements, here's how the result column can be calculated: For vendor X: Result = Price * (1 - Share of business) = 20 * (1 - 0.70) = 20 * 0.30 = 6 For vendor Y: Result = Price * (1 - Share of business) = 10 * (1 - 0.30) = 10 * 0.70 = 7 So, the comparison based on the...

Okay... you're still encountering an error with your code. Debugging can be a bit tricky, but let's try to identify the issue. Can you provide more details about the specific error message you're receiving?

I can siggest steps as unable view your file. To create a pie chart in Excel based on the data you provided, you can follow these steps: 1. Open your Excel file and go to "Sheet1" where you want the pie chart to appear. 2. Select the cells containing the language and article data. 3. Go to the...

This change should ensure proper formatting and hopefully resolve the "expected array" error. Let me know if it works!

Replace This dateString = Format(currentDate, "MM/dd/yyyy") With This dateString = Format(currentDate, "mm/dd/yyyy")

No, the line 'Application.EnableCancelKey = xlDisabled' will not solve the 'Product deactivated' message issue in Excel. This message typically indicates a problem with the activation status of your Microsoft Office product. You should ensure that your Office subscription or license is active...

That's great...

I think there is date format issue, however modified code for you Sub InsertDateColumn() Dim ws As Worksheet Dim todayDate As Date Dim currentMonth As Integer Dim months As Variant Dim i As Integer Dim month As String Dim lastColumn As Integer Dim headers As...

Modified as required Sub MultipleRegressionAnalysis() Dim ws As Worksheet Dim rngY As Range, rngX As Range Dim lr As Long ' Set worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your worksheet name ' Find last row of data lr =...

Here's a step-by-step guide: 1. Open your Power Query Editor. 2. Select your data source. 3. Add a custom column (let's call it "Overlap Check") with the following formula: = if List.Count( List.Select( Table.SelectRows(#"PreviousStep", each...

Hello Can you please show what error you are facing with the formul

This code performs thensame task using VBA Sub InsertDateColumn() Dim ws As Worksheet Dim today As Date Dim currentMonth As Integer Dim months As Variant Dim i As Integer Dim month As String Dim lastColumn As Integer Dim headers As Variant Dim columnIndex As...

Great..Please do let us know!

May be! =IF(OR(ConsonantCount(LEFT(A1, 4))>=3, ConsonantCount(LEFT(A2, 4))>=3), TRUE, FALSE) UDF Function ConsonantCount(str As String) As Integer Dim i As Integer Dim consonantCount As Integer Dim vowels As String Dim letter As String ' Define vowels vowels =...

Sorry Marc....Noted!

Try This! Sub MultipleRegressionAnalysis() Dim ws As Worksheet Dim rngY As Range, rngX As Range Dim lr As Long ' Set worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your worksheet name ' Find last row of data lr =...

Hello Iam assuming your dynamic chart is embedded as a chart object in the worksheet named "Sheet1". Update the sheet name and chart object name accordingly and try Sub CreateChartVideo() Dim ws As Worksheet Dim chartObj As ChartObject Dim i As Integer ' Set the worksheet...