Forum

Oh, by the time we got the question and example clear I'd forgotten you didn't want to use a PivotTable, sorry. You need Microsoft 365 or Excel 202...

Hi Priscilla, The formula you're using the generate the title must be affected by the filter on the State slicer. It's hard to say without seeing a...

Hi Stephanie, Thanks for clarifying. You can use a PivotTable (with data added to the data model) to do this. You need to include the 'Items' field...

Great to hear! The files didn't get attached. After selecting the file you need to press 'Start upload' and then wait for the grey check mark before s...

Hi Valerie, It's very difficult to follow without a sample file. The KPI visuals require a date dimension, so maybe you haven't given it enough inf...

Hi Stepahnie, Thanks for sharing the file. I'm a bit confused as you say you want the value for those with an amount of zero. How would I be calcul...

Hi Sebahattin, Yes, you can add more conditional formats (one for each project) that colours the cells, but if you have a lot of projects, then it'...

Hi Adam, Glad you've found our site helpful! Unfortunately, you can't add conditional formatting arrows to a Pivot Chart. Here's an example of a...

Hi Bouskila, Please provide a sample Excel file of your data and desired result so I can understand what you're working with. Mynda

Hi Max, It sounds like you're not using a tabular layout for your source data. If you were, then you could create a PivotTable report from the data...

Hi Laura, I can't see the very bottom of your screen. There should be an arrow there which is 'get data'. Mynda

Hi Ayal, To find the address of a cell, you can use the CELL function like so: =CELL("address",B2) Alternatively, the current cell address is...

Hi Chris, I think what Velouria is alluding to is to clear all filters, then set the formatting, then reapply the filters as required. This will ap...

Hi Sarfraz, Follow the link for the tutorial on Text.Select. Then see tutorial 3.05 on merging queries. Mynda

Hi Sarfraz, That formula is woefully inefficient. You can use this simpler formula nowadays: =TEXTJOIN("",TRUE,IFERROR((MID(D2,ROW(INDIRECT("1:"...