Forum Discussion
How to use duplicates in Excel
Hi SergeiBaklan,
I've actually just solved my problem by doing the following formula in the next empty row.
=IF(COUNTIF($A$2:$B$1007;A2)>1;A2;"")
This returns me every instance that is a duplication.
But thanks a lot for your time 😀
Could you please clarify on which Excel platform/version you are, and by adding the row you mean another row at the bottom where each duplicate will be in separate cell (i.e. column), or that shall be just long text in one cell with dates separated by delimiter, or something else.
Hi SergeiBaklan,
I've actually just solved my problem by doing the following formula in the next empty row.
=IF(COUNTIF($A$2:$B$1007;A2)>1;A2;"")
This returns me every instance that is a duplication.
But thanks a lot for your time 😀
Ok, thanks for sharing