Separating Duplication in Bus Obj.. 1

[m3gd04]

Hi there, newbie here...

I have a column called case numbers (case_num). In this field I have numerous
duplicates that I separate out. After exporting to Excel, I create a second
column that carries the following formula:

IF(COUNTIF($A$1:$A$100,A2)>1,"Duplicate")

From here, all "duplicates" are displayed in this 2nd column which I then
exclude by filtering out.

In Bus Obj, I'm trying to implement same idea but haven't had luck. I've used
Count & CountAll, but I'm not experienced enough to make it work.

Any advice as to how to achieve same results like in Excel would be greatly
appreciated, thus eliminating need to export to excel.

m3gd

 

[blom0344]

There are multiple solutions to this problem.

Top of my head:

Use a variable that reads:

= If(Previous(<case_num>)=<case_num>) Then "Duplicate" else ""

Apply a global filter on this variable to exclude the rows with the duplicate in them...

Ties Blom
Information analyst
tbl@shimano-eu.com