Conditional

Reading Time: 2 minutes  Finland’s National Police Board has prohibited BML Group Ltd. from marketing its gambling services in Finland in violation of the Finnish Lotteries…

You don’t need a complex expression to add conditional formatting to a filtered PivotTable in Microsoft Excel. Image: Diego/Adobe Stock Microsoft Excel PivotTables range…

AP Photo/David RichardThe Cleveland Browns traded quarterback Baker Mayfield to the Carolina Panthers in exchange for a conditional 2024 fifth-round pick.Carolina Panthers @…

Reading Time: 2 minutes  The Australian Communications and Media Authority (ACMA) has requested Australian internet service providers (ISPs) to block the illegal gambling…

Reading Time: < 1 minute  Sweden’s Supreme Court will hear a case on whether lottery operator Svenska Spel must hand over details of its commercial agreement with…

Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with a conditional formatting rule to…

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.…

Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature. Image: monticellllo/Adobe…

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how. Image:…

Reporting lots of large values in Excel is probably a good thing, but if you want them to be readable, try this easy technique. Image: 200dgr/Shutterstock The article,…