Forum Widgets
Latest Discussions
Using Filter to return rows with certain conditions
I want to return the rows where "maturity date" column is higher than "Asofdate" or is lower than "IssueDate". I tried this formula =FILTER(INDIRECT(C12&"[#All]"),(INDIRECT(C12&"[MaturityDate]")<INDIRECT(C12&"[IssueDate]"))+(INDIRECT(C12&"[MaturityDate]")<INDIRECT(C12&"[AsOfDate]"))) but it gives me #Value error. What would be the correct formula? C12 definitely has the correct table name so can't pin pointAnkit137Jun 24, 2025Occasional Reader25Views0likes2CommentsExcel IF/IFS formula not calculating scenario "B"
Hi, Hopefully an easy solution that's staring me in the face, but I've been trying to fix this for an hour and I'm getting nowhere. Any pointers appreciated. I've been working on a new calculator workbook and in the final stages I'm having issues with the IFS function. The workbook will calculate a different total for each cell depending on the scenario chosen. I have two variable outcomes, due to a known value only being possible for either S15 or S21 (and the unknown value being resultant/residual). Cell S15 = A residual or fixed number dependant on toggle selection Cell S21 = A residual or fixed number dependant on toggle selection I have two "control" cells that determine the fixed value of S15/S21 as applicable. The control for S15 is Z17 and the control for S21 is Z18. The other cells referenced in the formula below are all subtotals of either revenue or cost. I have managed to get S15 to calculate correctly using only the following "IF" formula as such: =IF(S9="YES",SUM(N52+N57)-(S16+S17+S18+S19+S20+S22+S43+S49+T64),Z17) This completes the residual calculation if the scenario is "YES". It defers to cell Z17 if "NO" is selected. Perfect. On the second part of the equation I cannot get it to calculate correctly. So far I have tried: =IF(S9="YES",(N52+N57)*Z18,SUM(N52+N57)-(S15+S16+S17+S18+S19+S20+S22+S43+S49+T64)) This returns the correct calculation for "YES" no matter the list selection. =IFS(S9="YES",(N52+N57)*Z18,S9="NO",SUM(N52+N57)-(S15+S16+S17+S18+S19+S20+S22+S43+S49+T64)) This returns the correct calculation for "YES", but returns a blank for "NO".dsdansJun 24, 2025Copper Contributor41Views0likes3CommentsSuddenly excel slows down or crashes with history files
Good morning, I am a italian A1 volleyball data analyst (female) and I use Excel to create my match sheets. Opening one of my files in the last few days the file blocks the application or slows it down so much that it is not possible to use them. I have w11 and Office 365 personal updated to the latest versions. I have already uninstalled and reinstalled Office 365 but the problem persists. Opening the file from "Libre Office" there are absolutely no problems and I have been using these files for at least 3 years in Excel.gustavo_gallottiJun 24, 2025Copper Contributor34Views0likes2CommentsInvalid procedure call or argument (VBA Error 5 Excel) in Build 19011.20000
Version 2507 (Build 19011.20000) gives the following VBA error in Excel: "Invalid procedure call or argument (Error 5)" It stops at the following line in VBA: === qv_wiel = WorksheetFunction.Min(3 * wiellast / (2 * Pi * Sqr(Sqr((x_wiel - x0) ^ 2 + (y_wiel - y0) ^ 2) ^ 2 + H_eq ^ 2) ^ 2) * Cos(WorksheetFunction.Radians(WorksheetFunction.Degrees(Atn(Sqr((x_wiel - x0) ^ 2 + (y_wiel - y0) ^ 2) / H_eq)))) ^ 3, wiellast * 4 * (1 / 4 - 1 / (2 * Pi) * (WorksheetFunction.Asin(2 * H_eq * Sqr((4 * H_eq ^ 2 + L_strook ^ 2 + B_strook ^ 2) / ((4 * H_eq ^ 2 + L_strook ^ 2) * (4 * H_eq ^ 2 + B_strook ^ 2)))) - 2 * H_eq * L_strook * B_strook / Sqr(4 * H_eq ^ 2 + L_strook ^ 2 + B_strook ^ 2) * (1 / (4 * H_eq ^ 2 + L_strook ^ 2) + 1 / (4 * H_eq ^ 2 + B_strook ^ 2)))) / (B_strook * L_strook)) === This issue didn't exist in Version 2506 (May 2025) and lower.wiensJun 24, 2025Copper Contributor21Views0likes1CommentQuicken transactions copy to Excel
I'm trying to copy transactions from Quicken Deluxe, and paste those transactions to Excel (as I've been doing for over 20 years). When I try to paste those transactions to Excel, only first 25 transactions will appear in Quicken. Can anyone help?janwJun 24, 2025Occasional Reader22Views0likes1CommentCreate table using LET based on column values
Hi all Hope you can help. I am trying to create an output table based on another tables column data. Example: Original Data Table: Task Target Group 1 Group 2 Group 3 Group 4 Task 1 10 5 10 Task 2 20 10 Task 3 10 5 15 16 Task 4 50 90 10 20 19 Output Table Desired: Tasks Team Result Task 1 Group 1 5 Task 1 Group 3 10 Task 2 Group 2 10 Task 3 Group 1 5 Task 3 Group 2 15 Task 3 Group 3 16 Task 4 Group 1 90 Task 4 Group 2 10 Task 4 Group 3 20 Task 4 Group 4 19 Any advice where to start please? ThanksMatt_PazJun 24, 2025Copper Contributor190Views0likes9CommentsExcel FILTER function not working with some formulas
Hey all, Very weird issue: The FILTER function doesn't return anything when the target cell contains certain (but not all) formulas. For example, it would work if I manually type 0.1 but it will NOT work if I have a =11.9-11.8 formula. It DOES work however on =0.05+0.05 or = 2.9-2.8. I tried formatting the cells every possible way - general, number, indentation, etc and no go. Attaching some screenshots. Could you help me out?SolvedBreakingBadlyJun 24, 2025Copper Contributor38Views0likes3CommentsIssue with INDIRECT formula
Hi Guys i am having an issue with running a Indirect formula to take intersect a column and a row of a "skill vs will" matrix to give an intersecting answer. I have created from a selection in the name manager section in formulas, have set drop down lists for each column and used the formula =INDIRECT(I18) INDIRECT(J18) It is only affecting 2 rows from the matrix but other than that it works Anyone got any tips?SolvedFrostyboy86Jun 24, 2025Copper Contributor39Views0likes2Comments
Resources
Tags
- excel42,847 Topics
- Formulas and Functions24,858 Topics
- Macros and VBA6,442 Topics
- office 3656,087 Topics
- Excel on Mac2,666 Topics
- BI & Data Analysis2,399 Topics
- Excel for web1,938 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,655 Topics