Last seen: Jul 3, 2025
Hi Herman, You can do this with a pivot table, then from Pivot Table analyze tab tools in ribbon, choose Options-Show Report Pages. This action ...
Hi Bob, can you upload a sample file with your query? It will be easier for you if we give you a functional solution rather than a general theoretic s...
Hi David, Normally, a macro is needed after evaluating if the result cannot be achieved with excel's default tools. This is not the case, your data...
Hi, Can you put some manual results in the K3:O10 range, for our reference? It will be easier to see if we can get the same result with formulas.
Hi Anne, The file is corrupted, can you upload again? There can be many ways to do that. For example, you can add another column, to return true...
Hi Leah, Not sure I understand your question, if you copy and paste a cell with a comment (I guess the "notes" are cell comments), the comment is c...
You already have that. In column B, enter the function like this: =FnConvert(A1)
Hi Ray, There are already a few codes for that conversion. You should try them, it's much easier than writing a similar code from scratch, the code...
Hi Tom, In the ResetForm code, you refer to AssignedDate.Value, there is no control with that name in the form. There is a label, Label10, its capt...
Hi Nadeem, It's more like a math problem, rather than an excel problem. In your layout, DocDate U_ZONE Dscription Attribute Value ...
Hi Aye, What do you mean you're copying data to excel? By default, any query will load results to sheets. You can change that by right clicking the qu...
Hi Nadeem, My guess is that you don't have the date field displayed in the pivot, can you try attaching the file again? Without seeing a sample piv...
You should update first the power pivot add-in. For this, the only way is to download again the add-in and install it.
Nice, glad to hear you managed to find your way through, good job !
Trond Liavik said Running totals AMOUNT: There should be no flat graph from 201906-12, running totals is just repeating itself then. Here period amou...