Filter Specific Rows from Data

[Jmacnevin]

Hello,

I'm hoping someone can help me determine the most efficient way to filter specific rows from a data set.  Below is an example of the input and output I'm trying to achieve:

Essentially I only want to see scenarios where the TRX_NUMBER duplicates, yet the TAX_RATE_CODE is different.  I think a Multi-Row formula would do the trick, but I'm a relatively new user and have difficulty with that tool.

Any assistance would be appreciated.

Thanks!

[randreag · Accepted solution]

Hi @Jmacnevin 

I attached a workflow that i think will work 

I hope it helps

[christine_assaad]

Hi @Jmacnevin 

I tackled it a bit differently in case records won't be in order. Please check if this works for you. Cheers!

[Jmacnevin · Accepted solution]

Thanks @aruiz-itp !  That worked!

[Jmacnevin]

Thanks @christine_assaad!  That does work for me as well.

[Amarendra]

Hi @Jmacnevin You can use the summarize tool and filter in distinct count