Creating a Unique List with ADO

Date 21 August 2017
Author exceldepo
Category Macros
Type XLSM

An Excel file that teaches how to perform Creating a Unique List with ADO operation.

Excel Dashboard for Creating A Unique List with Ado

Usage of DISTINCT or GROUP BY is exemplified. The results are written to the page as a clean list. The list is used in verification and reports. Errors caused by repetition are reduced.

Hope it is useful.

ADVERTISEMENT AREA

Related Files