• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unique list

Thomas Kuriakose

Active Member
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
 

Attachments

Thomas Kuriakose

Active Member
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
 
Top