You have bug in Excel new dynamic unique function

Anonymous
2019-11-04T02:09:18+00:00

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.

Microsoft 365 Insider | Excel | Other

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.

0 comments No comments

6 answers

Sort by: Newest
  1. Anonymous
    2019-11-04T18:59:08+00:00

    Please let us know what platform you are using (Mac or Windows), and what version and build of Office you have installed.

    -Jesse

    Was this answer helpful?

    0 comments No comments