mardi 26 mars 2019

Excel merge 2 formulas

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