Hello Guys !
Here's what I'm trying to do.
Column A is my customers record.
Column B indicates whether the customer is New or not.
Column D is my Unique customer extracted List.
Reason why I did not put Cust C as he's not a new customer.
What formula should I input in Column E to return a "New" if D matches A and B lists as New ?
<tbody>
</tbody>
Thanks once again.
For some reason I've been brain dead today
Vel
Here's what I'm trying to do.
Column A is my customers record.
Column B indicates whether the customer is New or not.
Column D is my Unique customer extracted List.
Reason why I did not put Cust C as he's not a new customer.
What formula should I input in Column E to return a "New" if D matches A and B lists as New ?
A | B | C | D | E | |
1 | Customer | New | Customer | New | |
2 | Cust A | New | Cust A | ( New ) | |
3 | Cust A | Cust B | ( New ) | ||
4 | Cust B | New | Cust C | ||
5 | Cust A | ||||
6 | Cust B | ||||
7 | Cust C | ||||
8 | Cust C |
<tbody>
</tbody>
Thanks once again.
For some reason I've been brain dead today
Vel