• 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.

Count as one if you found same combination

Rizky Tony

New Member
Hi Guys,

I am having problem to ignore the combination (if already counted before) to count some thing..
Data
PO Number Activity Quantitiy 1 Quantitiy 2
a 3 1 0
a 3 2 0
a 2 0 0
a 1 1 0
a 1 3 2
a 1 4 4
b 1 1 1
b 1 0 0
b 2 0 0
b 2 1 0

Hopped result
Q1 Q2 Notes
a activity # 2 1 Number of activity having Qyt at least 1 for PO a
a quantity # 11 6 Number of Quantitiy for PO a
b activity # 2 1 Number of activity having Qyt at least 1 for PO b
b quantity # 2 1 Number of Quantitiy for PO b

Thank you for reading and helping

BR//RT
 
See attached.

If using Excel 2007 and newer see D17:E20
If using Excel 2003 see D25:E28
 

Attachments

  • chando ask_s.xls
    37.5 KB · Views: 0
Back
Top