Forum Widgets
Latest Discussions
Formula for if a date is more than X days in the past
Can someone help me with a formula for Excel? If Column A returns a set of dates, is there a function to show if the dates in Column A are more than 30, 60, 120 days in the past?SolvedO_edwardsKPPB-9Mar 22, 2025Copper Contributor26KViews0likes5CommentsCalculate "The Wednesday" two weeks before due date
We currently run checks on Wednesday of each week. To show an "anticipated pay date", I want to somehow use the "due date" of the invoice and return the date two Wednesday's prior. Is that even possible? For example, if the due date is Thursday, May 1st, I want it to return Wednesday, April 23rd. If the due date was Tuesday, April 29th or Wednesday, April 30th, I want it to return Wednesday, April 16th. I know how to return "two weeks ago", but since I only want Wednesday's that makes it a little more confusing. Is there a "2 (day of the week) ago" -type formula?RandomPanda1933Mar 22, 2025Copper Contributor19Views0likes2Commentsuse SUMIF for cell in immediate row above
Can someone please help me? I've been using this formula for 2 years and now I need to add another word and row/path to the filter (not sure of correct terminology) =SUMIF($B$2:$B$6,"Tithes*",$G$2:$G$6) Now, I need to add OR "processing*" to "tithes" and it can only be for processing fees in the row directly below tithes & offerings. If "processing*" is in a cell directly below a "tithe*" cell, then it should be included in the formula in K25. (I can figure out K26 & K27 if I can get K25.) Can someone please help me create the correct formula? I would be extremely grateful!BeckyBo334Mar 22, 2025Copper Contributor43Views0likes2CommentsDelimiter to be used
Dear Experts, I have a data like below:- So, each sub Packets[x], if has data will have Common and Chain as below, I want to bring Chains in the same level as the common, like this:- What delimiter shall , I use, to achieve this. Thanks in Advance, Br, Anupamanupambit1797Mar 21, 2025Iron Contributor62Views0likes1CommentPower Query by Default Excludes First Blank Column
I have researched this down the rabbit hole long enough without any answers. In Excel I created a Power Query Get Data from Sharepoint Folders using the Contents method. There are about 10 files where the data is in the same format, columns match sheets are all the same name, etc.... FYI, None of them are setup as Tables for reasons I won't go into. They just can't. When I import the files 5 of the files have data in column A while 5 do not. When I import the data the files that do not have data in column A Power Query is automatically removing those columns from those sheets. Which then screws up the column order when the data is appended and loaded to the table. How can I force Power Query to bring in Column A even if some files column A are blank?heylookitsmeMar 21, 2025Brass Contributor48Views0likes1CommentReturn multiple rows with matches
I am trying to compare a variable set of numbers that will be pasted in by a user with two different columns in a table and then outputting the rows that match in either column. I would like to eventually delete the duplicates this produces...but i cant even figure out the first part. I've tried combinations of V and X lookups, Index, Match and other random things to no avail. see below for an example of what I'm trying to achieve.mtiblierMar 21, 2025Copper Contributor52Views0likes2CommentsExcel 2021: Replace value in one cell based on the values of two cells (that cell and one other)
Greetings: I am using Excel to normalize some foreign-language bank data for my taxes. (Excel, and Notepad++ are excellent tools for data-conversion tasks!) Given the following data truth table Column A Column B [null] [null] <== no change !=null [anything] <== no change [null] !=null <== Column A should change to "XFR" In other words, if column B is not null, and column A is null, then column A should become the text "XFR" How do I implement this?jharris1993Mar 21, 2025Copper Contributor33Views0likes1CommentConditional Formatting on Mac
Hello, I am having trouble with conditional formatting on mac. I would like there to be a gradient or tri-color conditional formatting on a specific column. I can get it to work with the numbers but not the formula when setting the rule. For example, I can get the scale to work by setting a min/mid/max number: But I would like something more specific, like to have the red cells be percentages below 0%, white cells to be >0 and <= 10, and green cells to be >10%. However when I try to change this rule to a formula all of the cells turn white: I have tried to change what it is applied to but nothing seems to work for the formulas. Thanks a lot in advance and I appreciate the help.dfolk13Mar 21, 2025Copper Contributor23Views0likes1CommentWhat if Analysis, getting "copy and paste overlap" error
i am getting this error on a new table I am trying to create, as well as existing table that used to work in a different file. Is there a setting in Ecel that I could have changed that enables "What if" functionality?MaxGKMar 21, 2025Occasional Reader20Views0likes1CommentWhy does SUM not work for me ??
My worksheet has been generated by VBA from another master worksheet. By filtering data, and copy/paste. I am using office 365, and a simple =SUM(A2:A4) of 3 numbers (5,10,5) on that page does not work. It just displays 0.00 All the cells are formatted as a number. Any ideas pleasegray_b365Mar 21, 2025Copper Contributor73Views0likes5Comments
Resources
Tags
- excel42,422 Topics
- Formulas and Functions24,599 Topics
- Macros and VBA6,377 Topics
- office 3655,985 Topics
- Excel on Mac2,636 Topics
- BI & Data Analysis2,352 Topics
- Excel for web1,903 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,622 Topics