How to make the formula unique to ignore a column

will be helpful for those in need Is your convention implementing IConventionAcceptance (or the equivalent IPropertyConventionAcceptance)? From there, within the Accept method, you can access the "Formula" property and return true/false appropriately. This will prevent your convention from processing the property.

I wish did fix the issue. I have Excel Data like below , You can use the remove duplicate function
Select the column range

Any of those help I want to use if condition to perform ClearContents task. Please find my below code for the same. I written below 2 code's, but both are unsuccessful. , Write something like this:

If Not Cells(t,1).HasFormula Then

End if

Sub TestMe()

    If Not Cells(1, 1).HasFormula Then
        Debug.Print "No Formula"
    Else
        Debug.Print "Has Formula"
    End If

End Sub

To fix this issue You can use distinct function; By specifying the variables explicitly, you can retain unique rows just based on these columns; And also from ?distinct:

distinct(df1, name, is_fruit, .keep_all = T)
#    name ID is_fruit
#1  apple  1      yes
#2 orange  4      yes

help you fix your problem You need to apply this formula:
=ArrayFormula(COUNTIFS(ROW(A:A),"<="&ROW(A2),A:A,A2))=1

2 a
3 b
4 a
5 c
6 b

2 a
3 b
5 c