Morning all,
I'd like to replace the manual use of the advanced filter for showing unique records with a formula. In the example workbook on the "All WO Numbers" sheet there are 1465 lines containing Work Order numbers. On sheet "Unique WO Numbers" are the 177 unique values found on "All WO Numbers".
The 177 unique value were fetched by applying an advanced filter to 'All WO Numbers'!A:A then the results were copied and pasted to 'Unique WO Numbers'!A:A. Is there a way to use formulas to fill in these unique values automatically.
Thanks all!
Bookmarks