User Profile
Lorenzo
Silver Contributor
Joined 9 years ago
User Widgets
Recent Discussions
Re: Pivot Table Yearly Sales Report Issue
is there a way to directly convert the date to year within the pivot table without having to separately convert the date to year first and then use the pivot table? Yes and this is auto. done by the PivotTable when the Dates are actual Date values, not your case where your [Date] column contains Text values In attached file your data has been formatted as Table named SalesData > Routed that table to Power Query to change the [Date] and [Due Date] field types to Date > Build a PivotTable from the query > Added the [Date] field to Rows ==> The Pivot auto grouped the [Date] by Year, Quarter, MonthRe: Grouping
With the information you shared it's virtually impossible to answer your question... See if the following helps in the meantime Data formatted as Table named TableSource In column [Event ID] formula is (copied down): =IF( COUNTIF( SourceTable[[#Headers],[Group]]:[@Group], [@Group] ) = 1, [@Group], "" ) Filter [Event ID] unchecking (Blanks)Re: I don't understand this logic with StockHistory function...
There's no logic with STOCKHISTORY. The function pulls information, that's it. The logic you describe is yours Assuming you want to pull the last 10 days history for each stock/symbol in E4# and keep/display only the last day, one option: in F4: =LET( end_date, TODAY(), start_date, end_date -10, BYROW( E4#, LAMBDA(symbol, TAKE( STOCKHISTORY( symbol, start_date, end_date,, 0, 1 ), -1 ) ) ) )Re: How to use F2 for Excel on iPad Pro M4 with latest Magic Keyboard
Notes on https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f#PickTab=macOS says The shortcuts in this topic refer to the US keyboard layout. Keys for other layouts might not correspond exactly to the keys on a US keyboard Later on the same page the Control+U shortcut is documented: Notes on https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f#bkmk_cellsios&PickTab=Office_for_iOS says If you're familiar with keyboard shortcuts on your macOS computer, the same key combinations work with Excel for iOS using an external keyboard, too So, in principal (expect if doc. error), Control+U should work if you use a US keyboard. But maybe you use a different keyboard layout (???)
