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 

[ncrlelia · Accepted solution]

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

[xariet]

@ncrlelia that's perfect, thank you!