Hi Excel World,
I have a worksheet (Sheet1) and in column AY, there is a list of names with many duplicates. I want to have a copy of the list in another worksheet (Sheet2) without the duplicates but also for this list to be dynamic so if more names are added to sheet1, they appears in my list insheet 2. Can this be done in a formula or does it need VBA?
Thanks in advance
I have a worksheet (Sheet1) and in column AY, there is a list of names with many duplicates. I want to have a copy of the list in another worksheet (Sheet2) without the duplicates but also for this list to be dynamic so if more names are added to sheet1, they appears in my list insheet 2. Can this be done in a formula or does it need VBA?
Thanks in advance