Aug 30 2022 01:50 PM
I have in column ''A'' names repeated a few times I want in column 'B'' all the names from column a one time
Aug 30 2022 01:56 PM
Aug 30 2022 04:51 PM
Solution@wanalearn If you have Excel 365 there is a formula specifically for that:
=FILTER(UNIQUE(A:A),UNIQUE(A:A)<>0)
Aug 30 2022 04:51 PM
Solution@wanalearn If you have Excel 365 there is a formula specifically for that:
=FILTER(UNIQUE(A:A),UNIQUE(A:A)<>0)