Forum Widgets
Latest Discussions
Controlling Formula Output in Excel Based on Cell Entry
Scenario Description In this scenario, cell B1 in Excel contains a value of 50. Cell B2 uses the formula =B1+25-A2 to calculate its value. When the number 25 is entered into cell A2, the result in B2 is 50. Desired Outcome The objective is to ensure that cell B2 remains empty until a value is entered into cell A2. Currently, B2 will display a result regardless of whether A2 has an entry. The goal is to prevent B2 from showing any value or calculation until A2 contains data. Question How can this behaviour be achieved in Excel so that B2 only displays a result after an entry is made in A2?
"all the merged cells need to be the same size" during a Custom Sort
On ASUS StudioBook x64 PC, Windows 10 Pro for Workstations, ver. 20H2 (OS Build 19042.1288)Microsoft 365, EXCEL ver. 2109 (Build 1443020306) ... While attempting to do a custom sort of an EXCEL table of 96,600 + records, I received an error stating "all the merged cells need to be the same size during this operation" Following online help directions for finding merged cells, none were found! (I didn't knowingly create merged cells, but when clicking Options > Format > Alignment, under Text Control, both "Wrap text" and "Merge cells" have their squares filled in with black fill.) The same error occurs when I attempt to sort the field 'editinitl' (A to Z) in the table. The field holds 3-character-long abbreviations of persons name in capital. Why is this message occurring when the suggested find procedure finds no merged cells? Here's the procedure I tried to find the merged cells. Find merged cells You may encounter an Excel worksheets that has https://support.office.com/en-us/f1/topic/merge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf?NS=EXCEL&Version=90 that you don’t know about. This can be frustrating because Excel doesn't sort data in a column that contains merged cells. Following the steps below, you can find all the merged cells in your worksheet and then https://support.office.com/en-us/f1/topic/merge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf?NS=EXCEL&Version=90. Click Home > Find & Select > Find. Click Options > Format. Click Alignment > Merge cells > OK. Click Find All to see a list of all merged cells in your worksheet. When you click an item in the list, Excel selects the merged cell in your worksheet. You can now https://support.office.com/en-us/f1/topic/merge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf?NS=EXCEL&Version=90. Need more help? You can always ask an expert in the Excel Tech Community or get support in the https://go.microsoft.com/fwlink/?linkid=827514.
Linking a cell from a OneDrive excel sheet to another OneDrive excel sheet in different workbooks
Hi, I'm trying to make a cell in sheet A of workbook 1 display the cell from sheet X in workbook 2. Both workbooks are in the same parent folder with different sub folders. I want all this to be done with OneDrive apps, not desktop app. Any help would be greatly appreciated! Thanks
Trying to insert Pivot Table
I recorded a new macro, using the tab View Macros-Record Macro, which resulted in the following VBA code: Sub CreatePivotTable() Sheets("Year Data").Select Range("A3:F24").Select ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "Year Data!R3C1:R24C6", Version:=xlPivotTableVersion14).CreatePivotTable _ TableDestination:="Yearly Summary!R3C1", TableName:="PivotTable3", _ DefaultVersion:=xlPivotTableVersion14 Sheets("Yearly Summary").Select Cells(3, 1).Select End Sub The recording did exactly as I wanted, taking the data from the "Year Data" WS and adding the new pivot table to the "Yearly Summary" WS. As a test of the macro, I deleted the initial pivot table that was created on the "Yearly Summary" WS. The problem I have now, when I attempt to run this macro again it constantly fails on the 4th line of the macro with Run-time error '5': Invalid procedure call or argument. ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "Year Data!R3C1:R24C6", Version:=xlPivotTableVersion14).CreatePivotTable _ TableDestination:="Yearly Summary!R3C1", TableName:="PivotTable3", _ DefaultVersion:=xlPivotTableVersion14 I cannot figure out why it works when I am recording the macro but fails when I try to run it alone. Help is greatly appreciated.
Specific Rounding Rules
Howdy! My job has a bit of a weird rule for their rounding technique. I was curious if there is a way I can format my cells or write a function that allows for it. The rule is as follows: If the number your rounding is proceeded by a 5, instead of rounding up, you look at the number being rounded. If it is even, you rounding down else you round up. Basically you want the number your rounding to remain at an even number if it's being rounded by 5. Is there a way to get this rule into excel? Thanks in advance for the help!
#Name? error in a formula adjusted for circular reference
How can I solve #Name? error in formula: =H2+(I2*Parameters_2026!$G$1)+(I2*Parameters_2026!$G$3)+(I2*Parameters_2026!$G$5)+((I2-I2*Parameters_2026!$G$1-I2*Parameters_2026!$G$3)*İNDEX(Parameters_2026!$C$3:$C$7;MATCH(MAX(I2;1);Parameters_2026!$A$3:$A$7;1))). Where: H2 → Net Salary I2 → Gross Salary (to be calculated iteratively) Parameters_2026!$G$1 → Employee Social Insurance Rate (0,14 of Gross Salary) Parameters_2026!$G$3 → Employee Unemployment Insurance Rate (0,01 of Gross Salary) Parameters_2026!$G$5 → Stamp Tax Rate (0,00759 of Gross Salary) INDEX + MATCH → Finds income tax rate (range C3:C7) applicable for Gross Salary amount (A3:A7 range) Iterative calculation enabled for Maximum Iterations: 1000 and Maximum Change: 0.000001. Thank you in advanceNeed help with conditional fomatting formula based in text on cells
Hi everyone, I have a list of owners' names in column C. C2 contains 1+1 CAR CORPORATION C3 contains 8-J ENTERPRISES, LLC C4 contains LOYD RENTALS LLC C5 contains SMITH PAUL & PAULA C6 contains DOE JHON & JANE C7 contains MENENDEZ JAMES C8 contains BROWN INVESTMENTS, INC. And so on I'd like to highlight the whole row for the cells that have CORPORATION, LLC, INC, ENTERPRISES in their names. Hope this makes sense and someone can help me. Thank you.
