Search results

Hello Chavezz, That's a smart approach! While the TEXT function works perfectly to extract the day of the week, at ExcelDemy, we often recommend using the Format Cells option with a custom format like dddd to achieve the same result while keeping the original date intact. It's another simple...

Hello Thurley, Here is the updated Activity on Node (AON) diagram, representing the tasks and their dependencies based on the provided data. Each node shows the task ID, description, and duration in days.

Hello Thurley, To create an Activity on the Node (AON) diagram, we need the dependencies for each activity. This information determines the flow and sequencing of activities. If no dependencies are provided, the AON diagram assumes all activities are independent, which is unlikely in most...

Hello Shin, You can achieve this time in and time out using Google Apps Script. Barcode Scanner: Use a USB barcode scanner (plug-and-play) or a mobile scanner app to input the ID into a Google Sheet. Apps Script Automation: Use Google Apps Script to capture the scanned ID, date, time, and...

Hello Rona, You must use the custom format to format the date to show only the day. Select the date cell >> Format Cells >> Custom >> type d. You can watch our video tutorial: How to Create Leave Tracker in Excel

You are most welcome. I'm glad to hear that it worked perfectly. Keep helping each other in the forum to make the community stronger.

Hello Jogec, You can use the following formula: =IF(ISNUMBER(SEARCH("h", A2)), LEFT(A2, SEARCH("h", A2) - 1) * 60, 0) + IF(ISNUMBER(SEARCH("m", A2)), MID(A2, IF(ISNUMBER(SEARCH("h", A2)), SEARCH("h", A2) + 1, 1), SEARCH("m", A2) - IF(ISNUMBER(SEARCH("h", A2)), SEARCH("h", A2) + 1, 1)), 0) +...

You are most welcome. Thanks for your feedback and appreciation. Keep helping each other.

Hello Jznance, Thank you for your question! You can achieve this in Excel using a combination of COUNTIF or COUNTIFS formulas to track and count entries based on names across different sheets. Here’s how you can set it up: Master List (Sheet 1): Have a list of names in one column (e.g...

Hello Jogec, You can use the following formulas but must maintain a proper time format to get the correct result. Convert to Total Minutes: Once the time is correctly formatted, multiply it by 1440...

The additional levels (e.g., Moving Deviation, Reverse Deviation, and Midline) could be calculated using more specific formulas. Moving Deviation (High & Low): These levels might deviate from the pivot points using specific multipliers. High Moving Deviation: High Moving=High+(High−Low)×X...

Hello Akram Hassan, Based on your image, some extra levels like "Moving Deviation" and "Reverse Deviation" aren't standard Pivot Point calculations. These could be derived using variations of the High, Low, and Pivot Point values with some specific multipliers or averages. Possible Formulas...

Hello Akram Hassan, To create a program that calculates pivot points and related levels (R1, R2, S1, S2, etc.), you can implement this in Excel using formulas. Here's how you can approach both: Pivot Point Formula: Pivot Point (PP)=(High+Low+Close)/3 Resistance Levels: R1=(2×PP)−Low...

You are most welcome. Keep exploring Excel with ExcelDemy.

Hello Muh, I understand you're still facing issues getting your VBA code to run automatically upon reopening the workbook. Let's walk through the process step by step to ensure everything is set up correctly: Step 1: Open the VBA Editor Open your workbook. Press Alt + F11 to open the VBA...

Hello Muh, It sounds like the VBA code is not being triggered when you reopen the workbook. To ensure your code runs automatically when the workbook is opened, you need to place the code in the ThisWorkbook object in the VBA editor, specifically in the Workbook_Open event. Here's how you can do...

Hello Faisal, Unfortunately, Excel does not natively support dual-axis bar charts where each category (SAP, H2) can have a separate scale. However, here are a few workarounds you could try: Use a Combo Chart with Secondary Axis: Create a Combo Chart by selecting your data. Assign "SAP" to the...

Hello Faisal, Thank you for sharing your detailed requirements and the file. While I’m happy to provide suggestions and guidance, I encourage you to adapt the earlier solutions to your specific needs. This can be achieved using a formula that tracks the current date and adjusts calculations...

Hello Jululian, Here's the final solution using the working formula to extract the desired values based on two criteria: Formula: =SORT(UNIQUE(FILTER(C4:C33, ISNUMBER(MATCH(D4:D33&E4:E33, K4:K6&J4:J6, 0))))) Explanation: MATCH: Combines D4:D33 and E4:E33 to evaluate both criteria, comparing...

Hello Jkondrat14, Here’s a comprehensive guide to consolidating data from 300 individual sheets into a Master sheet in Excel: Option 1: Power Query (No Coding Needed) Load Data from SharePoint: Go to Data > Get Data > From File > From SharePoint Folder. Enter the SharePoint folder URL and...