I'm making a table to check duplicate data. Where data that wants to be duplicated is in the "Sampel1" column and the duplicate checking results are in the "Status" column.
The formula that I have made is:
=if(COUNTIF($A$3:A3, A3)>1, "Duplicate", "No")
I want when table 1 is filtered only for duplicates, the results can be seen in the picture below: