Identifying Single Rows in Grouping

[greenman73]

I am trying to identify a single row in a grouping.  So in the grouping the first group has 4 unique rows, second group has 3 unique rows but then the third only has one unique row.  I need my output to show me all of the rows in the grouping that are a single unique row.  I cannot figure this out or find any solution in the forum.

Here is my current Workflow

The output puts the numbers for grouping

Any assistance is greatly appreciated!

[atcodedog05]

Hi @greenman73 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

[gabrielvilella]

Hey @greenman73, sample data and desired output would be nice. I believe what you need is the Unique tool, and then check all fields that each record needs to have unique values. 

[greenman73]

Hello - thank you for the assistance.

So this is what i am tasked with.  I have customers with different levels of access.  But in some cases there is only one row of access showing.  I want to identify those single rows.  There are over 20k rows in my sheet.  I already have rules set to identify certain combinations which are considered violations but i cannot figure out how to identify rows with just one access showing.

Each person has a unique ID but the access level can be one of 60+ different levels.

Input would be something like this:

Output goal would be to show the one row with the one access level showing regardless of the level of access.

[atcodedog05]

Hi @greenman73 

Here is how you can do it.

Workflow:

Hope this helps : )

[greenman73 · Accepted solution]

Perfect!  Output is showing exactly what i need!  Thank you for the assistance!

[atcodedog05]

Happy to help : ) @greenman73 

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!