Evening everyone,
Please can yyou help with an issue. I am trying to remove any duplicates from a sheet using a formula so this does not have to be done manually. However the 2 formulas I have used, do not work when there is more than one entry. Can anyone help?
These are the 2 I have used, but I am at a loss!
Many thanks in advance
Please can yyou help with an issue. I am trying to remove any duplicates from a sheet using a formula so this does not have to be done manually. However the 2 formulas I have used, do not work when there is more than one entry. Can anyone help?
Code:
=IF(W4="","",IF(COUNTIF(W4:W9999,W4)>1,"",W4))
Code:
=IF(W4="","",IF(COUNTIF(W4:W9999,W4)=1,"",W4))
These are the 2 I have used, but I am at a loss!
Many thanks in advance