Harold Garcia
Board Regular
- Joined
- Jan 2, 2014
- Messages
- 72
Sir/Mam,
I would like to request for a formula that will categorize my data. As seen on table below, i have Member ID and Category. what formula will i use to have the Category to identify VIP and REGULAR customer. i have separated table that have the list of MEMBER ID which is VIP.
<tbody>
</tbody>
Thank You and hope to hear from you soon.
I would like to request for a formula that will categorize my data. As seen on table below, i have Member ID and Category. what formula will i use to have the Category to identify VIP and REGULAR customer. i have separated table that have the list of MEMBER ID which is VIP.
MEMBER ID | CUSTOMER NAME | CATEGORY |
PV1234 | JUAN | |
AN4321 | JOHN | |
EN5412 | FRED | |
FG4124 | ANNA |
<tbody>
</tbody>
Thank You and hope to hear from you soon.