Forum Discussion
Solved
is there a formula for this ?
I have in column ''A'' names repeated a few times I want in column 'B'' all the names from column a one time
wanalearn If you have Excel 365 there is a formula specifically for that:
=FILTER(UNIQUE(A:A),UNIQUE(A:A)<>0)
wanalearn If you have Excel 365 there is a formula specifically for that:
=FILTER(UNIQUE(A:A),UNIQUE(A:A)<>0)