Forum Discussion
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 specific ID. In this sheet i check for duplicates, and hightlight them with red (I use the Excel conditional formatting)
Now what I want to do is to "extract" all the data that is hightlighted. So essentially I would like to add a new row in this example containing the following data:
19. december 2023
20. december 2023
21. december 2023
..
30. december 2023
Is this possible?
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 😀
3 Replies
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
