Search results

The correct option for grouping the data in a summarized table to show the number of products for each type is: COUNT + GROUP BY In Power BI, you would use the COUNT aggregation function along with the GROUP BY statement to achieve this.

Hello Specialist Quick solution without looking at your attachment To dynamically match outflows with inflows based on "Product" and "Amount" and return the associated inflow date: 1. Assuming your data starts in Column A with headers: - A: Date (Inflows) - B: Product (Inflows) - C...

My perspective is to create a Bridge file in Excel for your dashboard: 1. Ensure that each source file (Revenue, Cost, etc.) has a common unique identifier (primary key). This identifier will be used as the linking field in your Bridge table. 2. Create a new worksheet for your Bridge table. In...

Creating precise cardiovascular risk formulas requires a detailed understanding of the specific risk factors and their corresponding weights in the chart. Since I can't see the chart, I can guide you on creating a formula based on general principles. Assuming you have columns for Gender...

Your approach to improve the data source by directing users to a constrained form for data entry is a wise first step. It can prevent issues stemming from inconsistent data formats. However, when dealing with existing data challenges, your outlined logic for cleaning and transforming dates in...

Hello Hunter You cano add conditional formatting based on the criteria you mentioned, you can follow these steps: 1. Select the cells in the Training Plan row where you want to apply conditional formatting. 2. Go to the "Home" tab in the Excel ribbon. 3. Click on "Conditional Formatting" in...

Hello Dani You can achieve your desired result, you can use the combination of formulas like IF, WEEKDAY, and TEXT in Excel. Here's how you can do it: 1. In cell B2, you can enter the following formula to get the start date: `=DATE(YEAR($B$1),MONTH($B$1),DAY($B$1)+7*(ROW()-1))` 2. In cell C2...

Hello My Suggestion is you can use the formula `=UTCNOW()` instead of `=NOW()` to force the display of UTC time consistently, regardless of the user's device or browser. This should help maintain consistency across various platforms for your embedded worksheet calculations.

Hello,it looks like you want to dynamically reference the name of the current sheet within your formula. You can achieve this by using the CELL function to get the filename of the current sheet and then extracting the sheet name using the TEXTAFTER function. Here's the corrected formula...

Hello Bines It sounds like you're looking for a single formula that can provide the solution without using volatile or concatenated functions. One way to achieve this is by using an array formula. For example, if you want to sum the values in column A and B and get the result in column C, you...

In Excel, you can use the SUMIFS function to sum values based on OR criteria while avoiding duplicate sums. The SUMIFS function allows you to sum values that meet multiple criteria. By using the OR logic in the criteria, you can sum values that meet at least one of the given conditions. A...

Please share more details to help you with..Thanks

Apologies for that, unable to do from mobile

Hello Sorry couldn't open your excel file, However Creating a macro to handle all these scenarios requires a bit of complexity. Assuming you are using Excel VBA, here's a basic outline for the macro: Now, let's break down the `ExtractDate` function: 1. Handling multiple date formats: -...

Hello Intresting question! If you want to duplicate a block of rows multiple times in Excel using VBA, you can use a simple loop. Here's an example code that duplicates the first 64 rows ten times: Check this code >>> You've noted same thing yesterday <<< >>> use code - tags <<< Sub...

Assuming your date column is in column A, and the corresponding DM and Operator columns are in B and C, respectively: 1. Create a new column for Month and Year: In an empty column, use the formula `=TEXT(A2, "mmm-yy")` and drag it down for all rows. This will give you the month-year format. 2...

Hello... You can use the following Excel formula to generate a grid with the specified conditions: 1. In cell A1, enter the formula: =IF(RAND() < (280-SUM($A$1:A1))/(744-ROW(A1)+1), 1, 0) 2. Copy this formula across 100 columns (from B1 to CV1). 3. Copy the entire row down to row 744. This...

Hello Quite Interesting Question. As per my knowledge you can achieve the desired behavior of allowing data entry and then locking it after saving the document, you can follow these steps: 1. Protect the Worksheet: - Select the range where you want users to input data (columns B to I and...

Hello Sorry Couldn't see your file, However, the formula you've provided is designed to highlight everything except for the first occurrence of a duplicate in a column. If you want to reverse the condition to highlight only the first occurrence and not subsequent duplicates, you can adjust the...

To create a macro in Excel to list all data above the average rate by 40%, you can use VBA (Visual Basic for Applications). Follow these steps:press Alt + F11 to open the Visual Basic for Applications (VBA) editor.Insert a new module by right-clicking on any item in the Project Explorer...

>>> use code - tags <<< Sub MoveFilesWithSameFirst7CharsToNewFoldersAndRenameMasterFolder() Dim sourceFolderPath As String Dim targetFolderPath As String Dim masterFolderPath As String Dim fso As Object Dim sourceFolder As Object Dim file As Object Dim targetFolder...

Hello Everyone, Happy to share some interesting stuff which is recently implemented by using VBA. How to extract attached email and save in our drive. Apologies for any confusion. Here's the complete and combined code for downloading the zip attachment from Outlook and unzipping its contents...

Hello Experts. I am working on automation requirment using VBA to Auto create folder based on filenames and move the file into it's folder by creating folders as per the files. Step 1 Unzip the folder which consists of text files. Step 2 Creat a folder on todays date example : 12 Oct 22. Step...

Thanks Both. This is exactly what I was searching for..

Hello Seshin. Can I request you to provide excel attachment.