Forum Widgets
Latest Discussions
Calculate "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?
use 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!Power 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?
Return 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.Excel 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?
Conditional 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.Why 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 please
