Hi!
Need help please!
I want to create countifs formula to count how many unique PO's was issued for each buyer for 2012 with status Completed.
Countifs works fine but my problem is nesting a formula to determine only unique values.
Here below are sample table.
BUYER PO DATE STATUS
GOPA 692735 11/05/2012 Completed
GOPA 692090 13/10/2012 Completed
GOPA 706391 18/04/2012 Partially completed
CRIZ 697459 19/04/2012 Partially completed
CRIZ 697459 26/04/2012 Completed
CRIZ 697459 04/05/2012 Completed
CRIZ 697459 10/12/2012 Completed
CRIZ 697459 23/01/2013 Completed
CRIZ 697459 15/11/2012 Completed
CRIZ 697459 16/10/2012 Not compl.
CRIZ 697459 26/06/2013 Completed
CRIZ 697459 06/12/2012 Completed
CRIZ 696494 30/04/2013 Completed
CRIZ 742422 04/12/2012 Completed
GOPA 704663 24/04/2012 Completed
GOPA 701281 24/04/2012 Completed
GOPA 699192 07/09/2012 Completed
CRIZ 700892 12/06/2012 Completed
CRIZ 695038 26/04/2012 Completed
CRIZ 695020 24/05/2012 Completed
CRIZ 698305 04/11/2013 Completed
CRIZ 698318 04/11/2013 Partially completed
GOPA 698281 18/12/2012 Partially completed
GOPA 730951 05/10/2012 Completed
CRIZ 695524 09/10/2012 Partially completed
Bookmarks