• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

remove duplicate

A

Afarag

Member
Hello there,

please, I need help as I have a column which has a duplicated values within Date Range, that I keep one value then blank the other duplicated value at the same day.

I used a simple function at Column I, but it needs to keep columns sorted
 

Attachments

  • remove duplicates.xlsx
    20.7 KB · Views: 11
Maybe,

In I2, copy down :

=IFERROR(SMALL(IF(FREQUENCY(H$2:H$145,H$2:H$145),H$2:H$145),ROWS($1:1)),"")

Regards
 

Attachments

  • RemoveDuplicateAndSort2.xlsx
    22.1 KB · Views: 7
I see the values has been changed, it must be figured out like column H, but without duplication, just keep one of duplicated values then blank the others
 
You must log in or register to reply here.
Back
Top