Does anyone know if it's possible to remove duplicates from a name list? My data is set up very much like it is set up on this contextures spreadsheet.
If you go into that spreadsheet and click in the drop-down list for Prod where the selection is currently "Large Cap Equity", you'll see that there are duplicates.
My data that I'm making duplicate lists for is set up just like this spreadsheet. All my data is in a table form like this contextures example. I would like to use the code that is in this spreadsheet for my spreadsheet but I need to get rid of the duplicates. Is there away to code that Validation Source reference so that it removes duplicates? The code for that particular cell is: