Last seen: Mar 19, 2025
You can achieve this with Power Query or if you have O365 the GroupBy Function Power Query let Source = Excel.CurrentWorkbook(){[Name="tbl_te...
Seems to have loaded correctly and I was able to open the file without issue.
If column 3 is blank, then the Mcode will sort on the remaining two columns. See the example attached
A Power Query Solution let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Sour...
Thanks for the feedback. Post here again if you need more assistance with building your PT. Good Luck.
Katherine Maybe this, but what if A1 is not blank and C1 is not greater than Z1. I assumed a blank =IF(A1="","",IF(C1>Z1,B1-C1,"")) Also ha...
See the attached file that uses a Vlookup function
Slicer is working in the attached. Not sure of your issue. Inserted slicer based upon Name. Am I missing something?
one more xpost: /p>
also crossposted at: /p> and
MS has issued an update (2502) and Data Type has been restored as well as StockHistory.
I noticed this yesterday also. Additionally, I noticed that Data Types are no longer on the Data Ribbon. I am using O365 Beta Insider release 2501. ...
Suggest you attach a file that shows sample data that is representative of your actual file. Then mock up your expected results so that we understand...
The print in your picture is too small to read. You would be better served attaching your workbook for analysis.