The "UNIQUE function" in Microsoft Excel 365

Copper Contributor

I saw is "unique function in MS excel 365 that can remove duplicates dynamically, But this function is NOT added in MS excel 2016

 

How to use the "unique function" in Excel 2016 to removes duplicates dynamically ?

 

NOTE: I don't want any alternatives. 

1 Reply

@ahmadali3991 

If no alternatives that's only to upgrade on Excel 365 or Excel 2021 or use Excel for web.