I have a list with names in column A Sheet 1. Each name appears several times. I would like to list each name once in Sheet 2. Basically sheet 2 is a copy of the filter list in column A sheet 1, but I would like it to be dynamic so that it stays updated with the list in column A.
i.e: if a new name is added to column A sheet 1 several times - the list in Sheet 2 will add it once.