Flag customers who have multiple occurrences

[Jholiday78]

Hi,

I am looking for a simple solution to identify customers who meet the criteria of 1, 2, 3 in the 'Occurrence' column and flag as 1 so I can then use only those customers going forward in my analysis.  Everyone else should be excluded.  I'm trying to use the multi-row tool to accomplish this, but not sure if it is the right tool.

I've attached sample data with my desired output.

Thanks in advance,

Jessica

[binuacs]

@Jholiday78 one way of doing this wihout multi-row formula

[Qiu · Accepted solution]

@Jholiday78 
I am sorry but mine is not really "simple" per se😂

It make things abit complex since you only want to flag the first occurence per each customer.

[Jholiday78]

Thanks Binuacs,  I wish I could do this, but I need to carry through the customer id.  Thank you though for looking at it.

[SPetrie]

This still isnt exactly simple, but it isnt terribly complicated either.

[binuacs]

@Jholiday78 updated the workflow

[Jholiday78]

I was way off.  I thought I could just use a multi-row formula.  This worked perfect.  I could actually stop at the filter for 'Concat_Occurance" because those are the customers that where there ids showed up in all cases (1, 2, 3). 

Thank you,

This worked perfect and I appreciate the help.

[Jholiday78]

Thank you to all who responded with solutions.  There's more then one way it seems to solve my issue.