Identifying Single Rows in Grouping

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!

Workflow

Accepted answers

greenman73

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

All comments

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703