Flag customers who have multiple occurrences

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

Multi-Row Formula_Identify Duplicates.yxmd

Data Investigation

Accepted answers

Qiu

@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.

Multi-Row Formula_Identify Duplicates-r1.yxmd

All comments

binu_acs

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

Multi-Row Formula_Identify Duplicates.yxmd

Qiu

@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.

Multi-Row Formula_Identify Duplicates-r1.yxmd

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.

Multi-Row Formula_Identify Duplicates.yxmd

binu_acs

@Jholiday78 updated the workflow

Multi-Row Formula_Identify Duplicates.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703