Hi,
I have a file which contains data having one column having name UNIQUE_ID
I need to remove duplicate rows correponding/ comparing column UNIQUE_ID.
I tried countif formula to search the number of entries.
Please assist.
Thank You
kdraghu
Hi,
I have a file which contains data having one column having name UNIQUE_ID
I need to remove duplicate rows correponding/ comparing column UNIQUE_ID.
I tried countif formula to search the number of entries.
Please assist.
Thank You
kdraghu
Post an xlsx file, since you are using excel 2007.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Dear Sir,
.xlsx file is attached.
Thank You
On which criteria the rows need to be deleted.
I do not see the expected result in your file.
Edit, maybe this formula will do
H2 =IF(countif($B$2:$B$44,$B2)=countif($B$2:$B2;$B2),"","delete") and drag down.
after that filter on column H and choose delete, after that delete those rows.
Last edited by oeldere; 06-01-2020 at 07:52 AM.
Dear Sir,
If any record of column "UNIQUE_ID" is duplicate, the entire row need to be removed.
The formula provided by you is not working.
Thank You.
If all records in the row needs to be the same you can use this one below.
H2 =A2&B2&D2&E2&F2&G2
G2 =IF(countif($H$2:$H$44,$H2)=countif($H$2:$H2,$H2),"","delete")
Thank You oeldere for your support.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks