Hello,
I have a table of Visit information for various customers.
I need to identify what we consider as our customer, which means that if the customer visited our store (Store1)
In the Table below I need to get the column OurCustomer
<tbody>
</tbody>
Please help how I can achieve the above result.
I am a newbie in excel and working with excel 2010.
Thank you
I have a table of Visit information for various customers.
I need to identify what we consider as our customer, which means that if the customer visited our store (Store1)
In the Table below I need to get the column OurCustomer
Customer ID | Store | Visit Date | Store1 | OurCustomer |
Jon1 | Store1 | 4/1/2018 | Y | Y |
Jon1 | Store2 | 3/26/2018 | N | Y |
Jon1 | Store2 | 11/20/2017 | N | Y |
Doe1 | Store2 | 3/15/2018 | N | N |
Doe1 | Store2 | 2/10/2017 | N | N |
Jane1 | Store1 | 2/10/2018 | Y | Y |
Jane1 | Store1 | 3/20/2015 | Y | Y |
<tbody>
</tbody>
Please help how I can achieve the above result.
I am a newbie in excel and working with excel 2010.
Thank you