find duplicated value to modify

[Afarag]

i want to split some data as per its duplicate: i have 2 row, 1st include "Activities" eg: Excuse, Meeting and coaching. 2nd row have IDs. i want add anther row contain if An ID have the same activity 3 times eg "Excuse", want to modify the activity name to be first one be Excuse, 2nd will be Excuse 2, 3ed will be Excuse 3 ect...

 

[Somendra Misra]

Try in E2 and copy down:

=Table1[@Activities]&" "&IF(COUNTIF($B$2:B2,B2)=1,"",COUNTIF($B$2:B2,B2))

Regards,

 

[Afarag]

as usual Audi you have get it answered

Gratefully,

 

[Debraj]

In C2.. try this..

=[@Activities]& " " &IF(COUNTIFS($B$2:B2,[@[Emp Id]],$A$2:A2,[@Activities])=1,"",COUNTIFS($B$2:B2,[@[Emp Id]],$A$2:A2,[@Activities]))

 

[Somendra Misra]

@Afarag

I think you need to modify your formula to
=IF(COUNTIF($B2:$B$2,B2)>1,A2&" "&COUNTIF($B2:$B$2,B2),A2)


Regards,

 

[Afarag]

Yup i noticed that so that cleared the post

 

[Afarag]

In C2.. try this..

=[@Activities]& " " &IF(COUNTIFS($B$2:B2,[@[Emp Id]],$A$2:A2,[@Activities])=1,"",COUNTIFS($B$2:B2,[@[Emp Id]],$A$2:A2,[@Activities]))

Hi Debraj,

your formula too get the exact answer, thanks