Need to remove duplicate entries in multilevel BOM

[Sekars]

Hello Friends


I need to remove the duplicate entries in multilevel BOM based on the Part number and Level number.


My intension is by formula if I got `R' for remove then I will make a filter and I will remove it.


thanks in advance.

[kersplash]

Why not just use Data -> Remove Duplicates?

[FDibbins]

I think you missed some?
C10 and C11?

Anyway, I used this...
=COUNTIF($C$2:C2,C2)
copied down.

You can then just filter on >1

[FDibbins]

Why not just use Data -> Remove Duplicates?

Have to be careful with that, and make sure the whole row (record) is removed.

[Sekars]

Hello

Please read the C10 content as `SRE1461' instead of `SRE146' also. The formula <=COUNTIF($C$2:C2,C2)> removing all the entries instead of the first one.

Legend making the requirement clear.

Also " . . . Why not just use Data -> Remove Duplicates? . . . " Hope Remove duplicate will not work since we need to consider only 2 columns B and C but need to select all columns here.

[Sekars]

After long thinking i have found 1 solution myself.

I3 = <=IF(AND(EXACT(B3,B2),EXACT(C3,C2)),"R","")>, Copy down.

[FDibbins]

After long thinking i have found 1 solution myself.

I3 = <=IF(AND(EXACT(B3,B2),EXACT(C3,C2)),"R","")>, Copy down.

That will work if the duplicates are all together.

Did you try my suggested formula?