Hi,
I want to return first occurrence of non zero in column C per customer ID (Column A) So for example:
I want the formula to return 3 and 16 for customer ID 5 and 6 (very right is the result). Basically for customer ID 5 they had zero for product ID 1 and 2 so product ID 3 is the first non zero amount for this customer.
Can this be done?
I want to return first occurrence of non zero in column C per customer ID (Column A) So for example:
I want the formula to return 3 and 16 for customer ID 5 and 6 (very right is the result). Basically for customer ID 5 they had zero for product ID 1 and 2 so product ID 3 is the first non zero amount for this customer.
Can this be done?
Customer ID | Product ID | Amount | Customer | Product ID | |
5 | 1 | 0.00 | 5 | 3 | |
5 | 2 | 0.00 | 6 | 16 | |
5 | 3 | 50.00 | |||
5 | 4 | 150.00 | |||
6 | 14 | 0.00 | |||
6 | 15 | 0.00 | |||
6 | 16 | 230,349,112.64 |