Way to filter the data

[k3pineapple]

Hi

 I would like to find a way to to generate 3 reports, sample below: (May need to design loop If or for, not sure which one i need to use.)

1. Find out the company which has Sales and Account in some IDs, but missing conditionally in accounts and sales column

2.Find out the company which never has Sales before, but can have account.

3. Find out the company which has neither of them,  but only has company and ID

ID	Company	Account	Sales Person
10	ABC	12345a	Apple
11	ABC	12345b
12	ABC	12345c	Banana
13	ABC
14	XYZ	12345e
15	XYZ
16	TYU	12345g	Cherry
17	TYU	12345h
18	FGH
19	BNM

Expected out 

1. 

ID	Company	Account	Sales Person
10	ABC	12345a	Apple
11	ABC	12345b
12	ABC	12345c	Banana
13	ABC
16	TYU	12345g	Cherry
17	TYU	12345h

2.

14	XYZ	12345e
15	XYZ

3..

ID	Company	Account	Sales Person
18	FGH
19	BNM

Thank you for your help

[Qiu · Accepted solution]

@k3pineapple 
In this case, I consider the column "Company" will be the key column.

[binuacs · Accepted solution]

@k3pineapple 

[k3pineapple]

Really helps, thank you

[Qiu]

@k3pineapple 
Glad to be helpful. 😁

[k3pineapple]

something new learning , advance version for me, thank you,