Hi All,
Looking for some help on array formula to extract a unique list. In column A, I have a list of customer numbers, which in many cases are repeated i.e. there are duplicates. In column B, I have year and in column C I have month. I would like to extract a unique list of customer numbers for say Jan 2014 i.e. 2014 in column B and Jan in column C.
In column A, each customer number will appear more than once for each month and year combination, but I only need that customer account number to appear once in the unique list.
Many Thanks for any help
H
Looking for some help on array formula to extract a unique list. In column A, I have a list of customer numbers, which in many cases are repeated i.e. there are duplicates. In column B, I have year and in column C I have month. I would like to extract a unique list of customer numbers for say Jan 2014 i.e. 2014 in column B and Jan in column C.
In column A, each customer number will appear more than once for each month and year combination, but I only need that customer account number to appear once in the unique list.
Many Thanks for any help
H
