Another handy one, useful if you have a table you want to quickly remove duplicates from. This is handy when i want a quick list made from a single column of a query result, or for any reason need to remove duplicate rows from a table.
When it clears a row, it's from the table only (not the entire row). So, won't harm other tables...useful when putting something together for a quick one off job and for whatever reason you don't want a pivot table. Figure shows before/after.
Please Login or Register to view this content.
Bookmarks