remove duplicate

[Afarag]

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

 

[bosco_yip]

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

 

[Afarag]

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