10-10-2019 03:30 AM
10-10-2019 04:00 AM
10-10-2019 04:01 AM
There are several ways you can extract the unique items from a list.
In case of Array Formula, assuming your list is in A2:A25, place this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of Enter alone.
Confirm with Ctrl+Shift+Enter and copy it down until you get blank cells.
Adjust the range referred in the formula as per your requirement.
You may also create a Dynamic Named Range and refer it in the formula instead of referring ranges.
If you plan to place the above formula in another column, don't forget to change the bold column letters in the above formula as per your formula column.
Please find the attached with Array Formula, Dynamic Array Formula and Pivot Table solutions to get a unique list of names.