Last seen: Jun 10, 2026
I can also refresh it on: M365 on Win10Enterprise M365 on macOS Sonoma Office 2019 on Win11 (ARM version in a VM) Perhaps it's a fire...
In 2019 that would definitely not be a small change! I can't think of any way offhand without a lot of helper columns and/or terrible performance. ...
Enter it with Ctrl+Shift+Enter then copy down.
Which version (and build, if 365) of Office do you have?
Right-click the link and choose Save Link As... instead of just clicking on the link normally.
FWIW, if you don't want the additional column, you can amend the FILTER formula to do the same work: =FILTER(Source[Name Product],BYROW(Source[Cate...
For 2019 I think you can just remove the FILTER function from Riny's formula and replace it with IF: =TEXTJOIN("/",,IF(Table1[item Code]=B4,Ta...
What is your connection? I have several reports that run off files in sharepoint that are open (usually in Teams) most of the time, and have never had...
I don't think so. You can add one rank column that ranks on both of those columns, but not two separate ranking columns in one operation.
If you just want it to look like that, then yes, certainly.
The data in that field is not a List
If you click to the right of one of the Error values, what does it show you for the error?
I'd definitely use a table. What's the original data source? Can you use Power Query to get the data from it directly into the table, rather than copy...
I'm not aware of any way to force users into their own sheet views. I don't really follow your question about Lists - can you elaborate? My th...
Power Query is part of Power BI, so you can do all the same data manipulation, before getting into the presentation aspects.