Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Binge Fischer   on Feb 23 In MS Office Category.

  
Question Answered By: Jimmy Abp   on Feb 23

built-in excel functions will work:

add column  C with Absolute function: =ABS(B2)
then drag the function down the data  column.
add column D with the CountIf function: COUNTIF(C$2:C$10,C2)
then drag the function down the data column.
Then sort column D ascending; your 'duplicates' will be at the bottom of the
list.

Share: 

 
 
Didn't find what you were looking for? Find more on How to delete duplicate thru vba Or get search suggestion and latest updates.


Tagged: