Formulas & FunctionsExcel
← All topics
Excel

Formulas & Functions

XLOOKUP, LET, text and date functions — the formulas people actually ask about.

64this week
324last 30 days
15sources
Most activer/excel 163MrExcel Message Board 115Stack Overflow — [excel] 10Planet Python 9Stack Overflow — [vba] 5
Weekly Formulas & Functions briefing

The few items worth your time, every Tuesday. Nothing else.

Free. One email a week. Unsubscribe in one click. · RSS

Latest in Formulas & Functions

02

TEXTJOIN/FILTER on non-empty cells

Heya, I'm trying to create a textjoin/filter formula that concatenates results into a string where for 1 out of 2 filter criteria it applies to any cell that's not empty. For example if my data looked like this:

Q&A · r/excel ·
04

SUMPRODUCT formula returning #DIV/0!

I am trying to make a little budget worksheet just for fun. I want it to track income and tax over however long I use the budget sheet, and I want it to total each week's income and tax correctly even when future weeks…

Q&A · r/excel ·
07

Calculating marks to next grade, as identified by vlookup

Hi, Have a spreadsheet for the first Mock tests in a GCSE class. The grade is inputted using vlkookup from a table at the bottom of the sheet (N123-Q130) Foundation Foundation Higher Higher 0 U 0 U 29 1 36 3 69 2 53 4…

Q&A · MrExcel Message Board ·
12

Sumif help

Hi all, Can anyone help please, I have the following formula =COUNTIFS(Latest!C:C,B2,Latest!D:D,">=10") which works fine , but I also need this in another cell as a sum of the same using the same criteria in (B2) but…

Q&A · MrExcel Message Board ·
14

if() is not short circuiting the linked cell

Whatever I do I don't seem to be able to stop excel from evaluating the linked cell formula, even if the condition is false: =IF(FileExists("Null.xlsx"), '[Null.xlsx]Sheet1'!A1, "") Excluding my FileExists() function…

Q&A · r/excel ·
15

IFERROR function in Excel

I have an old Excel formula that is no longer working I have recently updated my laptop, and I think Excel might also have been updated. This is the formula in question: IFERROR(FIND("CABU",G2),FALSE),"Companion…

Q&A · Stack Overflow — [excel] ·
20

Choosecols - using a sequence of column numbers.

Is there a way of compiling a list of sequential column numbers to use in the CHOOSECOLS function instead of listing the numbers individually? I have many more columns to choose than four and I have to state them twice…

Q&A VBA & Macros · MrExcel Message Board ·

Related topics