A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Please let us know what platform you are using (Mac or Windows), and what version and build of Office you have installed.
-Jesse
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Just been figuring out why all results did not match when i first short unique and then sample data in power query. I took me hours to find out that short unique does not short all uniques. I had same text at beginning and then end of cell there where values 2,5 bar, 2,5 bar and
2,5 Bar. Unique values shows 2,5 bar and 2,5 Bar not 2,5 bar. When I change 2,5 bar to 2,5 bar. unique shows only 2,5 bar and 2,5 Bar was wanish. But exsample also same beginning text and value 1,2 bar and 1,2 bar the unigue function returned both values correct. So there must be some kind of bug of that function. I have not checked all but those came up from column witch has 60.000 rows.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Please let us know what platform you are using (Mac or Windows), and what version and build of Office you have installed.
-Jesse