Search results

Hello Tmbutter, You can use this Excel formula in F5 to return TRUE or FALSE based on whether the lookup value exists: =IF(COUNTIF(INDEX(A3:C6,0,MATCH(F3,A2:C2,0)),F4)>0,TRUE,FALSE) Explanation: MATCH(F3, A2:C2, 0): Finds the column number of the selected header in F3. INDEX(A3:C6, 0...

You're very welcome! 😊 I understand, Excel can be overwhelming at first, but don’t worry! The templates I shared earlier are designed to make things much easier. You can start by opening the template and entering your employees' names. The shifts will be structured based on the format you need.

Hi OffSim, Welcome to Excel! Yes, it's possible to create a roster that assigns morning (ED), late (LD), and rest days (RD/IN) for your 16 employees while ensuring they only work 2-3 shifts per month. You can use Excel formulas and data validation to automate the scheduling process. Here’s a...

Hi Efrenewat, You're right! Using an IF statement with COUNTIFS works well for this situation.

You are most welcome. Glad to hear that our solution worked. Keep exploring Excel with ExcelDemy. Let's help each other make the community stronger.

Hello Mike, You can use the following formula: =IFERROR(LARGE(IF(('Detailed List'!$C$4:$C$3004=BH$3)*(COUNTIF(BH$3:BH3, 'Detailed List'!$B$4:$B$3004)=0), 'Detailed List'!$B$4:$B$3004), 1), "--")

Hello Muh, To fetch the sales and profit values for these Employee Name, and Item Division from the sales sheet, you can use the SUMIFS formula in Excel. Sales Amount: =SUMIFS('Sales Data'!$G$3:$G$163, 'Sales Data'!$J$3:$J$163, E4, 'Sales Data'!$L$3:$L$163, F4) Profit Amount: =SUMIFS('Sales...

Okay. Hopefully, it will solve your issue.

It seems the shapes are not reflecting the visibility changes as expected, and the sheet tabs may not be working as intended either. Here's a full breakdown and updated guidance. Sub JAN() On Error GoTo ErrorHandler With Sheet1 ' Unprotect sheet if protected If...

Hello Mike, Thank you for clarifying! Based on your description, here's how to achieve the desired outcome. Array Formula for Unique Years in Descending Order: Since Excel 2016 doesn't have dynamic array functions like UNIQUE or SORT, you'll need to use an array formula: In cell BH4, enter...

Hello Mike, I reviewed the screenshot of your VBA code, and I see where the issue might be originating. The runtime error you are encountering when selecting a month tab and running the associated macro can be caused by several potential problems. This code includes checks to ensure that the...

Hello, You can achieve this using a combination of Excel formulas to eliminate duplicates, sort the list in descending order, and display the results as desired. Since you're using Excel 2016 and some newer functions like UNIQUE aren't available, here’s an alternative approach: Extract Unique...

If the calculation isn't returning the correct percentage, it suggests there might be an issue with either the formula range or how the conditions are interpreted. Here are some troubleshooting steps to ensure accuracy: 1. Check the Range in the Formula Verify that the range in the COUNTIFS...

You're most welcome! I'm so happy to hear that the explanation helped deepen your understanding. Exploring alternative formulas is a great way to work around Excel 2019's limitations. Alhamdulillah for your progress! 😊 Let’s continue to help each other, making this forum a valuable and popular...

Hello, To modify the formula to count values between 0 and 48 (inclusive), you can use the following formula: =COUNTIFS(A2:A100, ">=0", A2:A100, "<=48") COUNTIFS allows you to apply multiple conditions. A2:A100, "&gt;=0" ensures that the values are greater than or equal to 0. A2:A100...

Hello Mike, Thank you for your kind words! I'm so glad to hear that the solution is working well for you. If you have any more questions or need further assistance, don't hesitate to reach out. Let’s keep helping each other in the forum and make the ExcelDemy community even better together!

Hello Thank you for sharing the details of the dataset. Based on this, it appears that the formula you're working with is trying to match a value in the "Region" column ('Detailed List'!$T$4:$T$3004) with a value in V$3 and returns corresponding values from the "Producer" column ('Detailed...

Hello, You can use the following formula to calculate the percentage of values completed on or before the target value (e.g., 48 days). Assuming your positive values (number of days since completion) are in column A (starting from A2), and you want to compare it to a target of 48 days, you can...

Hello Firman, It seems like the issue you're facing may be related to how Excel 2021 handles array formulas differently, including using curly brackets. For the error you encountered, I suggest correctly entering array formulas (using Ctrl + Shift + Enter for array formulas in Excel 2019). If...

Hello Firman, Excel 2019 supports tables and structured references, but the behavior you're experiencing shouldn't be version-related. If the issue persists despite using correct syntax, it could be related to Excel settings or a potential corruption in the workbook. Are you using @ or it's...