Need help, to find the product Names which has repeated more than one time in the column.

[Sai0436]

Hello Community Need help,

I have a scenario. i have a "product name" column in the below mentioned table.
i want to create a column that should return the list of product names.
that each product repeated more than one time in the column. like below mentioned expected result column.
Need help.
Thank you.

Product name	Date	Expected Result
HYD0001	10/1/2023	HYD0001
HYD0001-MR1	10/2/2023
BAN0002	10/3/2023	BAN0002
BAN0002-MR1	10/4/2023
BAN0002-MR2	10/5/2023
CHE0003	10/6/2023
DEL0004	10/7/2023	DEL0004
DEL0004-MR1	10/8/2023

@Ashish_Mathur    Need help
@CoreyP       Need help

[v-shex-msft]

Hi @Sai0436 ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Sai0436]

Sorry Actually requirment got changed.
Requirment: which product name having both inital & Recert status. then we should return the initial staus record of that product.

Product name	Status	Expected Result
HYD0001-MR1	Initial	HYD0001-MR1
HYD0001-MR1 Recert	Recert
MUM0001-MR1	Initial
MUM0001-MR1 Insurance	Insurance
BAN0002-MR1	Initial	BAN0002-MR1
BAN0002-MR1 Recert	Recert
BAN0002-MR2	Turn
CHE0003-MR1	Initial
DEL0004-MR1	Initial	DEL0004-MR1
DEL0004-MR1 Recert	Recert

[Ahmedx · Accepted solution]

pls try this

https://1drv.ms/u/s!AiUZ0Ws7G26Rix4iQhtAFT83nofc?e=BxQIaS

[Ahmedx]

pls try this

[Sai0436]

Hi Ahmedx Could you please provide some other easy solution. User expecting the simple calculation.

[Ahmedx]

what do you mean simple solution?
like formula is unclear to you?