Search results

What does it meen?

Hello Alex Sub AdjustQty() Dim ws As Worksheet Dim lastRow As Long, i As Long ' Set the worksheet (change "Sheet1" to your actual sheet name) Set ws = ThisWorkbook.Sheets("Sheet1") ' Find the last row with data in column A lastRow = ws.Cells(ws.Rows.Count...

Hello Ana i think there might be a formatting or positioning issue with the combobox in Excel. Check the combobox properties, specifically the width, height, and location settings. Also, ensure that it's not anchored to a specific cell that might be causing it to appear in an unexpected...

My bad,i overlooked it..My Apologies to you vletm

Try this! =IF(C2="Y",SUM($B$2:B2)-SUM($D$1:D1),"")

All the best!

Great, Finally you got it.

Hello Prasad DN Thats the great question and my favorite only what you can doto make your read-me page in Power BI more visually engaging, you can consider using the following visualizations: 1. InfoCard Visual: - Use sections as InfoCard titles. - Bullet points can be represented as key...

Hello Jutu Let take another approach, i think It appears that the issue might be related to the way the `CONTAINSSTRING` function is used within the `SWITCH` statement. To resolve this error, you should modify the usage of `CONTAINSSTRING` so that it works correctly within the context of your...

Hey Jutu I think, try this line replacing CONTAINSSTRING({"B1CU|STMTOFACCT","GBW|BILLPRINT|CSV","S1STMT|ACCTSUMMARY","S1STMT|STMT"}, 'StagingVelocity LET_FORMATDATAARC'[LETCODE_CODE]) Replace to this CONTAINSSTRING("B1CU|STMTOFACCT|GBW|BILLPRINT|CSV|S1STMT|ACCTSUMMARY|S1STMT|STMT"...

Hello launder I can think of this based on your data...May be need more details to support you.If you want to return the correct corresponding numbers in Column B when there are duplicates in Column A, you can use the `INDEX` and `MATCH` functions. Assuming your data is in columns A and B as...

Hello Jb I have tried breaking down the steps into formulas: Assuming your data is structured as follows:-Apologies I haven't seen your File. - "event_list" sheet has the event names in column B starting from B4. - Sheets "tennis" and "cricket" have student data with Enrollment Number in...

@p45cal - Thanks for the advice! I'm still learning Excel and VBA, and I've been trying to navigate through the challenges. If you have any tips on how to construct better queries for AI or specific areas I should focus on, I'd greatly appreciate it.Thanks for the support

All the best!

I think you're looking for a specialized financial modeling software that handles depreciating fixed assets with consideration for taxes and depreciation. While I can't provide real-time updates on available software, you may want to explore financial modeling platforms like Quantrix, Synario...

It looks like you want to subtract the values in reverse order, adjusting for the DIFF column. Below is a VBA code that you can use to achieve this: Sub ReverseSubtraction() Dim ws As Worksheet Dim lastRow As Long, lastCol As Long, i As Long, j As Long Dim diffCol As Long ' Set...

=IF((C2="FTE" OR C2="Key Statistic") AND ABS(H2)>5%, "x", IF(ABS(F2)>250000 AND ABS(H2)>10%, "x", "")) Just modified what P45CAL sir suggested

Thanks for the update

Hello Belleka can be made dynamic as: =IFERROR(DATEDIF(MAX($B$2,DATE($F$1,1,1)),MIN(DATE($F$1+1,1,1),$C2),"M"),0 Here, I replaced the static reference F$1 with the dynamic reference $F$1, so if you copy the formula to another cell, it adjusts the reference accordingly.

Hello Jutu In Power BI, you can create a custom column using the "Add Column" tab in the Power Query Editor. While Power Query doesn't have a direct equivalent to the SQL CASE statement, you can achieve similar functionality using the following steps: 1. Open the Power Query Editor. 2. Select...

Hello Daparteka You can handle the error that occurs when the link is not found by using error handling in your VBA code. Here's an example modification to your code: On Error Resume Next ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources, Type:=xlExcelLinks On Error GoTo 0 This...

Please provide additional information to support you

Hello Shark If you want to change the values in a filtered column based on the values in another column while both columns are filtered, you can use VBA to loop through the visible cells and make the changes. Here's an example assuming you have a column "ColumnA" and want to change values in...

Hello Fat As per my experience to set up an alert pop-up in Excel using VBA for the expiry of an item, you can use the `Application.OnTime` method to schedule a macro to run at a specific time. Here's an example: Sub SetExpirationAlert() ' Set the expiration date and time (adjust as...

Hello DuneSage Certainly! You can use VBA to create a macro that automatically sends an email with the Excel sheet as an attachment on weekdays. Here's a basic example to get you started. Please replace placeholders with your actual values: Sub SendDailyEmail() Dim OutApp As Object Dim...