Some Handy Personal Macros: Clear-Duplicates-Below-Selection

[GeneralDisarray]

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.