Last seen: Jun 4, 2026
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.
This worked for me. let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Replaced Value" = Table.ReplaceValue(Source,"Notebook 5"...
Nothing attached. Please try again.
One approach I took was to create a pivot table in Power Pivot. Create a measure to group the unit codes and unit names.
crossposted: Suggest you read:
Cannot manipulate data in a picture. Please reattach a sample file with mocked up expectations.