Highlight Duplicate rows including first one

[Yashabh]

Hi All,

I have a requirement to highlight rows with duplicate line items in a Module. I have tried using the ISFIRSTOCCURRENCE along with conditional formatting but was only able to highlight the 2nd  duplicate row. I am using Concatenation to check duplicates within a unique key of 4 line items.

Would be great if someone can help with this.

Thanks!! 

[rob_marshall]

@Yashabh 

Can you give us an example? 

[Yashabh]

@rob_marshall  we have an module with 2 text formatted and 2 list formatted line items which will accept data using Excel Add in. I am exploring an option to highlight all duplicates (including the first one) without users having to trigger an action. 

[alexpavel]

@Yashabh  a way to do it is to create a list from the concatenation of the 4 line-items and create a summary in a module using this list from a numeric line-item with formula =1 on the source module. 

doubles will be the ones with the sum being  >1. 

[Yashabh]

@alexpavel  I did explore this option but we are using Excel Add in to submit data. Clicking the Action button to trigger Import to the list would be an additional manual activity, which i am trying to avoid. However as a last option would go with it.

[alexpavel]

@Yashabh Indeed.. it is needed to trigger an action to have this work calculated in Anaplan. 

not very much familiar with Anaplan Excel Add-In...but can't you combine Excel formulas to highlight the duplicates using Excel potentiality? 🙂

[CommunityMember126793]

@Yashabh , applied the check with the boolean and uses number format line item to pick the reoccurrences to highlight..

Below screen print for reference:

  

Let here know if this will help or not

[TonyViGrand · Accepted solution]

@Yashabh 

I have seen a similar post which could help.

Solved: Re: Count Duplicates Based on Text Field - Anaplan Community

The rows in Duplicates line item which have number more than 1 are the duplicates. I have shared screenshots which could help you too.

Hoping this will solve your problem.

Tony Grand

[Yashabh]

This worked!!

Great Solution @kevin.cho 

Thanks for referencing @TonyViGrand