Filtering by group number

xariet

Hi All

I have attached the input and desired output spreadsheet. I have groups and material numbers assigned to them. If a group has the same material numbers I need to get rid of it in the output. But if there is even one different material number I need to keep this group. I was thinking of using multi-row formula and creating a new column with ''keep'' or ''not'' values and then filtering out by this column, but I can't configure the multirow formula condition. Will be great if you can help. thank you 

Book44.xlsx

ncrlelia

Hi @xariet ,

We can acheive the output by finding out the distinct count of [mat #] for each Group, then filter out those Groups that have only 1 distinct [mat #]. Attached workflow for your reference.

Hope this helps.

Cheers,

Lelia

Workflow.yxmd