Forum

Hi Farshad, The tone of your email does not come across well. If you would like an answer to your question, it is courtesy to provide some data you...

Hi, As you've found, it's not possible to include a Sparkline in a PivotTable. Please see this tutorial on relative dynamic named ranges. Towards t...

Hi Tyrone, Thanks for sharing your file. Your formula is referencing the wrong cells. It should be as follows: On the Gender Selection Images sh...

Hi Sarfraz, I would use Power Query to bring the data in from the PDF and then tidy it up from there. Once you do this the first time, you can re-u...

Hi Azin, Welcome to our forum! Please provide an example file showing what you mean so we can help you. Mynda

Hi Tyrone, You could add an IF formula in say, cell H2 that says if there is data in cell G3 i.e. the slicer is either filtered for more than one s...

Hi Sarfraz, Please see the attached file. It comes down to your formula and the order of the formatting rules in the rule manager. As explained in ...

Ah, ok. Thanks for clarifying

Hi Sarfraz, I use that type of conditional formatting in my Project Management Dashboard. Here is a specific tutorial on just the Excel gantt chart...

Hi Courtney, Welcome to our forum! Your image didn't upload. You need to click the 'start upload' button after selecting the file and then wait ...

Hi Steve, Correct, you must aggregate the data by county for Map charts, but they aren't compatible with PivotTables. However, you can do this with...

Hi Sarfraz, If you have Microsoft 365 or Excel 2021, you can use XLOOKUP to find the last value in column E: =XLOOKUP(1E+100,E5:E20,E5:E20,,-1,2...

Hi Peter, I agree, this is very inefficient, and a lot of INDIRECT functions used like this can slow Excel down. I would use Power Query to gather ...

Hi Peter, This functionality is only available in Excel 365 or in Excel Online. You would need to save the file on OneDrive to enable sharing of th...

Hi and welcome to our forum! It sounds like your data is in the wrong layout. You shouldn't have separate sheets/tables for each month's actuals. I...