I have two formulas which I would like to merge into one, but dont know how to do it. I need to filter out blank cells and remove duplicates.
The first formula to remove blank spaces is this:
=IFERROR(INDEX($A$1:$A$500,SMALL(IF($A$1:$A$500<>"",ROW($A$1:$A$500)-ROW($A$1)+1),ROW(A1))),"")
Second formula will remove any duplicity.
=IF(COUNTIF(A$1:A1,A1)=1,A1,"")
Thanks!
Aucun commentaire:
Enregistrer un commentaire