Forum

Hi Amol, Welcome to our forum! Try this formula in cell D2 of your file, then copy down: =IF(COUNTIF($B$2:$B$21,"Not Match")=COUNTA($B$2:$B$21),...

Hi Aisha, Welcome to our forum! It's difficult to help without a mockup file. In future, please take a few minutes to create one and share it. F...

Hi Chris, See this tutorial on absolute referencing Table structured references, which explains the double square bracket technique like so: =CO...

Hi Shawn, You can't dynamically colour axis labels in charts. However, here are some ideas that you could use: Label events in charts Label m...

Hi Emmanuelle, Yes, but you haven't been clear on what that value represents e.g. is it YTD for the month selected in the Slicer, or the total for ...

Hi Casey, When you use INDEX you need to use it on both sides of the range operator e.g.: =INDEX(...) : INDEX(...) Or if the starting cell is...

Hi Justin, Slicers can only control a single table. If you want to control multiple reports, then you can create PivotTables from your Table source...

Hi Tyrell, Welcome to our forum! What other PivotTables are you trying to connect to? Where are they and what are they called? Note: only PivotT...

Hi Shawn, This problem existed in your original file shared on this forum, so I don't think it's related to any recent changes to names. It also is...

Hi Justine, Please upload your sample file. You need to click the 'Start Upload' button after selecting your file and then wait for the grey check ...

It can't be done in the PivotTable, sorry.

Hi Kenneth, If you have Microsoft 365 you can use this formula: =TEXTJOIN(", ",TRUE,FILTER(A4:A10,(ISNUMBER(SEARCH(B1,B4:B10))+ISNUMBER(SEARCH(B...

Hi Dieneba, Welcome to our forum! The Insert Data From picture feature is only available with 365 for Mac, Excel for iPhone and Excel for Androi...

"Bar charts only have nested axis labels for Pivot Charts or regular bar charts with more than one row of axis labels." In other words, you have a reg...

You need to do this in the Power BI model. Ideally this should be done in Power Query where you set the data types.