Search results

Hello Jonquil, Thanks for your explanation. Your formula is correct but the issue is in the absolute range you mentioned in the formula. Your formula...

Hello Jonquil, It sounds like you're facing a formula issue that stops at a certain row, and it's great that you're trying to resolve it. However, with so many sheets in the file, it’s difficult to pinpoint the problem without more details. Could you describe which sheet and row you're having...

You are most welcome. Keep contributing to the ExcelDemy forum by helping each other.

Hello Miraj, The hours list for the "TAT summary" sheet and the "TN TSR TAT" sheet were different. That's why COUNTIF is returning 0. I updated the hours range in the "TAT summary" sheet following the "TN TSR TAT" sheet. Download the Excel File:

Hello Naity, You can use nested IF statements to modify your formula to include different conditions based on store group. Here’s how to structure your formula: Using Nested IF Statements Assuming that the store group is indicated in column S and you have specific conditions for Store A, you...

You're welcome! Since the chart isn't updating automatically, could you please provide more information to help troubleshoot further? Here are a few questions that might help identify the issue: Which version of Excel are you using? Are there any external data sources linked to your table that...

Hello Naity, Thank you for your question! For better assistance from the community, could you please post your query in English? This will help ensure that more members can understand and respond to your request.

Hello, When you've formatted your data as a table in Excel, charts linked to that table should automatically update as you add or modify data. If your chart isn't updating automatically, here are several potential reasons and solutions to consider: Ensure the Chart is Properly Linked to the...

Hello, To filter your data in a specific format where each unique number in the first column has its corresponding values aligned in different columns, you can use the following formula. Formula: =FILTER(B$1:B$7, A$1:A$7=$A11) =FILTER(B$1:B$7, A$1:A$7=$B11) =FILTER(B$1:B$7, A$1:A$7=$C11) OR...

The problem of not highlighting the same cell going to the above or previous cell occurs when your cell reference is not aligned with your dataset. Adjust your formula: =ISNUMBER(MATCH(A2, Sheet2!A:A, 0)) Try with: =ISNUMBER(MATCH(A1, Sheet2!A:A, 0)) =ISNUMBER(MATCH(A3, Sheet2!A:A, 0)) Based on...

Hello Misaj, To highlight the country name of sheet 1 if it exists in sheet2, you can follow these steps: Go to Sheet 1 and select the range (select the range A2:A90 ). Click on the Home tab >> from Conditional Formatting >> select New Rule. In the New Formatting Rule window, select Use a...

Hello Imdurwood, It looks like you’ve done a lot of steps correctly! Here's how to ensure the macro works and to modify the code for your additional requests: Steps to Save and Run the Macro: To open VBA editor press ALT + F11. In the VBA editor, click Insert >> Module. Paste the full macro...

Hello Imdurwood, To count how many times each number touches highlighted cells in your dataset, you can use a VBA macro. Sub CountTouchingCells() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Change to your sheet name Dim r As Range, cell As Range Dim...

Hello SgtIk3, To avoid REF errors when using this formula: =VLOOKUP('Input Personnel Here'!A2,'Input Personnel Here'!A:K,1,FALSE) You can switch to INDEX and MATCH will help create a dynamic solution that adjusts when rows are deleted. Here's how you can rewrite the formula: =INDEX('Input...

You're most welcome! I'm glad to hear that it worked for you! Feel free to reach out if you run into any other issues. Keep helping each other to make the ExcelDemy forum beneficial for all.

Hello Waleed, To extract the numbers after the text "مرجع العملية", you can use a combination of TEXTBEFORE, and TEXTAFTER functions. =TEXTBEFORE(TEXTAFTER(A1, "مرجع العملية"), " ") TEXTAFTER(A1, "مرجع العملية"): Extracts the text after "مرجع العملية". TEXTBEFORE(..., " "): Extracts the text...

Hello Itsnatexd, Send an email automatically when conditions are met. You can follow this article: How to Send Email Automatically When Condition Met in Excel Send Emails from Excel

You are most welcome. Keep contributing to ExcelDemy forum and help each other to build a strong Excel community.

Hello, Office Scripts contains some methods that might not exist or may be incorrectly used. try this modified code but ensure that your Excel version supports these features, and consult the Office Scripts documentation for more updates. function main(workbook: ExcelScript.Workbook) { let...