Find duplicates in Fraction values

[Afarag]

Hello,

please i need help in finding the duplicates in Fraction values,
i have a data for Date, time, Date+time.
i can't apply the duplicate filter for that field Date+time called "Code"

thanks a lot,

 

[Deepak]

I didn't find any issue!

D2=COUNTIF([Code],Table1[[#This Row],[Code]])

 

[Afarag]

Okey it will figure out a result because it seemed applied to integer, but not to the fractions so when i apply the CF Duplicates find the entire is colored as a duplicated

i need to apply the function to figure out the duplicate for the fraction but not the integer

Thanks a lot,

 

[Chihiro]

You are getting every row highlighted because every row has duplicate.

 

[Deepak]

Hi,

First, You have marked entire column to a table range which will slow down the process!

CF is right as every cells in Code col is duplicated there! If you will select some less cells then look what CF produced.


You may use some formula in CF as per need.