Filtering out rows based on the same value in two columns

[overhead_press]

Hi everyone, how would I go about filtering out data that are the same in Amount1 and Amount2 column grouped by the Account number? Thanks!

Original:

Account	Amount1	Amount2
1	100
1		100
2	200
2		200
3	300
4		300

Desire result:

Account	Amount1	Amount2
1	100
1		100
2	200
2		200

[Athilingam_S]

Hi

You can use the custom filter Option with specific columns

[overhead_press]

Thanks for the response, what if I have a lot of rows and do not know the numerical values? How can I filter it without manually entering the numbers? 

[Athilingam_S]

Hi

If you can use this attached workflow for your Desire result

[mceleavey · Accepted solution]

Hi @overhead_press ,

I've built the attached workflow for you.

This pivots the data so the values are in the same column, it then removes empty values, pivots back to compare values for the same account number on the same line. Once we've determined the ones that match, use the Account to join back.

Hope this helps,

M.