Unique list

[Thomas Kuriakose]

Respected Sirs,

I need your guidance on how to extract a list of customers from the attached file. I tried using helper columns in I and J, but the actual list is having a lot of data and want to avoid errors.

a) Customers who fall in the category (C1:E1) with value greater than zero and are not in category (F1:H1)
b) Customers who fall in the category (F1:H1) with value greater than zero and are not in category (C1:E1)
c) Customers who do not fall in both (C1:E1) and (F1:H1) categories with value greater than zero.

Thank you very much for your support always,

with regards,
thomas

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[Thomas Kuriakose]

Respected Sir,

Thank you very much for this great solution. Apologies for asking one more, how to get list of customer who appear in both category.

Thank you very much once again,

with regards,
thomas

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[Thomas Kuriakose]

Respected Sir,

Apologies for the late reply. This is perfect, thank you so very much.

Much appreciated,

with regards,
thomas