Flag Column if Matches 1 record

[smusayev]

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

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

 

[Joe4]

Welcome to the Board!

Let's say that the data table you posted above is in cells A1:D8, where row one is your headers.
Then place this formula in cell E2 and copy down for all rows:

=IF(COUNTIFS(A$2:A$8,A2,D$2:D$8,"Y")>0,"Y","N")

This returns that values you are showing in bold.

 

[smusayev]

Welcome to the Board!

Let's say that the data table you posted above is in cells A1:D8, where row one is your headers.
Then place this formula in cell E2 and copy down for all rows:

=IF(COUNTIFS(A$2:A$8,A2,D$2:D$8,"Y")>0,"Y","N")

This returns that values you are showing in bold.

Thank you it worked

 

[Joe4]

You are welcome!