This tag is for Microsoft Excel questions where the question or answers are specifically about the structure, syntax, or output of an Excel formula.
I have list A with 259 items and list B with 626 items. There is some overlap between the list, so I …
excel excel-formula excel-2013I've seen PowerQuery expressions that can subtract days from a datetime, like DateTimeZone.UtcNow.AddDays(-1). However, I'd like to …
excel datetime excel-formula powerqueryWhen the results of an Array Formula are numbers, I find it generally easy to find an appropriate method to …
excel excel-formula array-formulasI'm trying to find the formula to automatically generate the Third Wednesday of Each month.I searched and found this: =…
excel date excel-formula weekdayI have created an Excel that includes a mapping file. What I am trying to do is have users enter …
excel excel-formula excel-2010 export-to-xmlI have a workbook with 11 sheets for each month, and one summary sheet. On each sheet is a list of …
excel excel-formula worksheet-function array-formulas consolidationI've got an Excel spreadsheet, with a Macro, that inserts a conditional formatting, like this: Selection.FormatConditions.Add Type:=xlExpression, …
vba excel excel-formula internationalizationThis question is actually for the Excel GUI, rather than Excel "programming", per se. However, if this is unavailable in …
vba excel excel-formula autofilterI'm setting up a spreadsheet with the goal of allowing users to enter data by employee and date. I'd like …
excel dynamic excel-formula excel-2016 excel-tablesI have a huge excel sheet that looks like this: ╔══════╦══════╦═════╗ ║ A ║ B ║ C ║ ╠══════╬══════╬═════╣ ║ Jack ║ 2001 ║ 1,5 ║ ║ Jack ║ 2002 ║ 2,0 ║ ║ Jack ║ 2003 ║ 1,0 ║ ║ Jack ║ 3001 ║ 3,5 ║ ║ Jack ║ 3002 ║ 4,0 ║ ║ Jack ║ 3003 ║ 1,0 ║ ║ Jill ║ 2001 ║ 3,0 ║ ║ …
excel excel-formula excel-2011