Forum

Hi Fausto, Welcome to our forum! I'm not sure what you mean by export, but if you double click on the grand total cell of the filtered PivotTabl...

Hi Marciano, Thanks for sharing the files and screenshots. In the data samples you shared here there is no data for February. Have you checked that...

Hi Marciano, Welcome to our forum! It's great to hear you're studying hard 🙂 Please try uploading your files again. Be sure to click the yello...

You can use this formula assuming your values start in row 2 of column T; =IF(OR(T2>T1,T3>T2),T2,NA()) Note: you should avoid using the sm...

Hi Ray, The above is the detailed answer 🙂 If you're experiencing errors I'd guess it's due to the data type, but without knowing the error or...

Hi Steve, Welcome to our forum! You could use the FILTER function to extract the matching cells and then count them, like this: =COUNTA(FILTE...

Hi Eric, The only guarantee of getting new features is to use the 365 versions of Office. Any perpetual licences typically only get bug fixes. If i...

In that case maybe you'd be better off doing this in Power Query.

Hi Peter, In row 6 of your notes it says if a player scores 37 they have a point deducted, and you have factored this into your formula: =IF((AN...

Hi Alberto, Measures are for the values area. I'm wondering why you can't you use that column in your PivotTable, rather than having to write it as...

Hi Mohammed, Welcome to our forum! It's difficult to diagnose the cause of the error, but if you're loading it to an Excel Table in the worksheet t...

Hi Robert, In Excel 2016 and later you can set the Slicer settings to 'hide items with no data' so that when you have other filters applied which r...

Hi Peter, To answer your first question "I think the code in column T is working but cannot get it to obey rule B; If the player scores about 36 bu...

Hi Lionel, The Task Completed Date formula needs the minus before the 1 in the last argument removed for the 'weekend' type, i.e. this: =WORKDAY...

Hi! Great to see you're practicing. The CUBE formulas in this example are finding the average, therefore the Grand Total is the total average. Note...