Highlight Duplicate rows including first one

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!!

Accepted answers

TonyViGrand

@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

All comments

rob_marshall

@Yashabh

Can you give us an example?

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.

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 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

@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

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385