Adding multiple criteria to FILTER and/or MAXIFS to return accounts with no recent orders-CodePudding

Home > OS > Adding multiple criteria to FILTER and/or MAXIFS to return accounts with no recent orders

Adding multiple criteria to FILTER and/or MAXIFS to return accounts with no recent orders

Time：09-30

I've been looking for a formula that will return accounts that have no recent orders.

It brought my attention that the corrected formula by @Harun24hr on G6 doesn't find the account: ACC1118. I checked that for Mark, this account doesn't have recent invoices. So maybe your original formula is not calculating what you want or I am missing something.

Page link：https//www.codepudding.com/os/561409.html

Prev:Can't figure out why excel is rounding currency

Next:get average of subtotal and wet with respect to distinct purchaseorderid and product category in DAX

Tags：

excelexcel-formula

Links：
CodePudding