Last seen: Mar 30, 2025
Do you have a value field in the pivot table? If not, you will end up with what you describe.
No. You have to open the workbook before you can do that, so you'd have to brute-force guess the password which would probably not happen in your life...
As Mynda alluded to, the results you posted are not the result of that formula with those inputs, so clearly one of them is incorrect. The results app...
Are you replacing the original file, or adding a new file to a folder? If the latter, did you use the From Folder option when creating the query? ...
No, not quite. You are using each List.Accumulate, so the List.Accumulate is processing the list in each row of the Custom column, one at a time. It i...
For each row, the List.Accumulate is processing each item in the list that is in the Custom column, and it loops through that list adding each item to...
I'd be very surprised if they are in 2024 given that the LTSC version of that came out before Checkboxes were on general release in 365. There is no m...
You might find it easier to move the Values field above the Year in the Column field area. That way, all the hidden columns will be together at the en...
If you use Power Pivot, you can do it by creating a column set. Assuming the years will change in the future, you'll either need to edit the set when ...
You can use Ribbon XML to disable or intercept those commands. Ron de Bruin's old Ribbon pages are now hosted on Jan Karel Pieterse's website thankful...
Cross-posted: mrexcel.com/board/threads/select-the-name-in-the-data-validation-list-on-a-cell-value-then-the-same-name-run-the-sub-macro.1263786/ ...
Will the item you want to select always be present? If not, what do you want to happen?
The code shown in your picture is not the same as the code in your post. The code in the post properly uses a fully qualified range (you specified the...
Glad we could help. 🙂
You cannot use functions on the ranges in a SUMIFS formula as that would return an array, not a range, and the function will not accept anything other...