Delete duplicate value for same date and other look up value.

[rtr.shazzad]

try:

Sub blah()
ActiveSheet.Range("$A$1").CurrentRegion.Resize(, 3).RemoveDuplicates Columns:=Array(1, 2, 3), Header:=xlYes
End Sub

Hi P45cal,
Thanks for your effort. But I was looking for something else.
I mentioned that I need to remove the duplicate values in HCFT column and other cell cell and rows will remain as it is.
Hope I can briefed well.

Shotez