Forum Discussion
Solved
How to use duplicates in Excel
Hi, I'm trying to use the duplicates i have found dynamically, i have a datatable containing all my data for multiple cases with different ID's. Then in another sheet i get all data from a sp...
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 😀
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