Search results

Hello Maps, You can use the following formula. =IF(OR(A33="",A33=0), "", IF(A33=-100, 0, IFERROR( VLOOKUP(A33,$A$3:$C$11,3,TRUE) + (A33 - VLOOKUP(A33,$A$3:$C$11,3,TRUE)) * VLOOKUP(A33,$A$3:$D$20,4,TRUE), "" ) ) ) Explanation...

You are most welcome. Keep Exploring Excel with ExcelDemy. Keep helping each other to make this community stronger.

Hello Shminhas, Use the following formula: =SUM(IF(ISNUMBER(SEARCH("Kg",A1:A5)), --SUBSTITUTE(A1:A5," Kg",""), 0))

Hello Shminhas, If your range contains some cells with "Kg" and others with "NA" or other non-numeric text, you need to modify the formula to ignore non-numeric values while summing only the cells that contain "Kg". Use the following SUMPRODUCT formula to only sum values that contain "Kg"...

Hello Shminhas, The formula you have used from our article is correct: =SUM(SUBSTITUTE(D5:D9," Kg","")+0) However, you're getting a #VALUE! error because this formula needs to be entered as an array formula or modified to work correctly with array inputs. The standard SUBSTITUTE() function...

Haha! Glad you got it working! Sometimes, it's just that one little tweak that makes all the difference. And hey, explaining Excel to a Luddite is a heroic effort in itself—props to you for trying! Happy Excelling with ExcelDemy!

Hello, It looks like the issue is likely related to one of these common problems: Cell Width Too Small: If the column isn't wide enough, Excel will display #####. Try expanding the column width. Incorrect Formula or Reference: Ensure you're using the correct formula, like: =A1 / 86400 +...

You're very welcome! 😊 I'm glad the confirmation helped you pinpoint the issue. The number vs. text mismatch can be a sneaky problem, but now you’ve got it sorted! If you run into anything else, feel free to ask—happy to help. Let’s keep helping each other and make the ExcelDemy forum a...

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...