Compare Descendent Row Data


What's the recommended function/formula combination to compare the Period and Final Amount data in order to identify duplicates? Note: The items being compared are in a composite list and share a parent. I would only want to compare items that roll-up to the same parent.  


In this example I want to flag any rows with the same Period and same Final Amounts. 



Best Answer

  • jasonblinn
    Answer ✓

    The first thing that comes to my mind would be to concatenate Parent ID & Period & Final Amount, and then use ISFIRSTOCCURRENCE to see if there are not the first occurrence (Or conversely, say NOT ISFIRSTOCCURRENCE to flag the items that are duplicates)