I hope I can articulate this properly.
In my spreadsheet I have a column of customer numbers and in another column I have dates on which they made a payment. There can be one or more of the same date for a customer number.
Customer 2134 could have 4 rows showing 10/23/17 and 1 row showing 10/24/17. This would count 2 unique dates for that customer number and this is what I need to return in a pivot.
Cust Payments
2134 2
Not sure if this is clear enough. Thank you in advance.
In my spreadsheet I have a column of customer numbers and in another column I have dates on which they made a payment. There can be one or more of the same date for a customer number.
Customer 2134 could have 4 rows showing 10/23/17 and 1 row showing 10/24/17. This would count 2 unique dates for that customer number and this is what I need to return in a pivot.
Cust Payments
2134 2
Not sure if this is clear enough. Thank you in advance.