Remove Duplicate option not working using expand selection method whereas the value in column G are numbers which are duplicate and highlighted

[kumail]

Remove Duplicate option in Excel is not working using expand selection method whereas the value in column G are numbers which are duplicate and highlighted using highlight duplicate option.

in this sheet in column G we have value that are numbers and duplicates are highlighted by using highlight duplicate tool. but when we use remove duplicate option by selecting column G and expand selection to all columns excel respond by prompt that no duplicate found. i have tried remove duplicate option by formatting numbers in various method but could not remove duplicates. Please Help.
Thanks in advance

 

[kumail]

Remove Duplicate option in Excel is not working using expand selection method whereas the value in column G are numbers which are duplicate and highlighted using highlight duplicate option.

in this sheet in column G we have value that are numbers and duplicates are highlighted by using highlight duplicate tool. but when we use remove duplicate option by selecting column G and expand selection to all columns excel respond by prompt that no duplicate found. i have tried remove duplicate option by formatting numbers in various method but could not remove duplicates. Please Help.
Thanks in advance

Hi Everyone,
i have found the solution i thought i should also share here for other people help so that if someone have same problem then they can have been helped through this reply.

Actually Remove duplicate option does not working normally when there are numbers as value in main column through which we are removing duplicate.
if we have to remove column G Dupicates with the other columns in sheets we have to go to data, click on remove duplicate options, then click on expand selection option, then unselect all in the option in popup box, then down in the same popup box there only check on the one column in which there are values (in numbers) in this case is column G and then click on OK. and that is all duplicates numbers will be removed. for further help two more snapshots are attached in this reply.