Quickly Find Duplicates in a Column
Sometimes a duplicate value can cause problems in Power BI/Excel. This is the fastest way I’ve learned to find a duplicate value in a column. Begin by bringing the column into Excel. Turn on the Filter for the column with duplicates. (From Home Tab, select ‘Sort & Filter’, then ‘Filter’ (Cntl-Shift-L if you want to…
Read more
Recent Comments