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