Filtering for where one column has multiple entries in another column

[Robotomation]

I have an extract as follows. I want to filter my extract for entries where one supplier has multiple G/L accounts. How would I get go about doing this? At first I thought of combining the the strings in Supplier and G/L Account together and then using the unique tool, but can't think of the solution (e.g. what if there are multiple entries where the wrong account was used)  

Extract

Journal Entry #	Amount	Supplier	GL Account
1	$100	Microsoft	123
2	$150	Apple	127
3	$200	Microsoft	234
4	$100	Google	235
5	$50	Google	900
6	$75	Apple	127

Output Expected 

Journal Entry #	Amount	Supplier	GL Account
1	$100	Microsoft	123
3	$200	Microsoft	234
4	$100	Google	235
5	$50	Google	900

[Cremo · Accepted solution]

Hi @Robotomation 

You can try the attached workflow. It basically counts the distinct GL account for each supplier and exclude those having only one distinct account (Apple in your example). Let me know if it helps.

[SPetrie]

Not sure if there is a better way, but one solution would be to use a summarize tool. Group by the Supplier and have a count distinct for GL Account. That will tell you if there are multiple GL accounts for the supplier.