Tag: excel

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