Snasui Excel Forum

Hi there,
Hi to everyone here,I need your expertise on this.
is there a way when I add a Same user in column 12 that already exist, it will retain the unique value in column D and remove the duplicate value?
Example highlight in color yellow"Dipika Yadav" already exist in row 7, but in column D the "CHS08" is the unique value that should retain and delete or remove(CHS02,CHS06) the duplicate.
Hope you can help me on this.

...

Try this.

E2

=IFERROR(LOOKUP(2,1/ISERROR(SEARCH(TRIM(MID(SUBSTITUTE(D2,",",REPT(" ",50)),(COLUMN($G2:$M2)-COLUMN($G2)+1)*50-49,50)),VLOOKUP(A2,$A$2:$D$11,4,0))),TRIM(MID(SUBSTITUTE(D2,",",REPT(" ",50)),(COLUMN($G2:$M2)-COLUMN($G2)+1)*50-49,50))),D2)

Norkaz

hi...
formula should be reference in Column C(UserID) not Column A (First Name)

...

If column C is the keyword, change the VLOOKUP columns reference as below.

E2

=IFERROR(LOOKUP(2,1/ISERROR(SEARCH(TRIM(MID(SUBSTITUTE(D2,",",REPT(" ",50)),(COLUMN($G2:$M2)-COLUMN($G2)+1)*50-49,50)),VLOOKUP(C2,$C$2:$D$11,2,0))),TRIM(MID(SUBSTITUTE(D2,",",REPT(" ",50)),(COLUMN($G2:$M2)-COLUMN($G2)+1)*50-49,50))),D2)

Norkaz

if I enter same user(Column C) it shows existing request in column E as seen in the image below. If column D is existing for user in column C can we have column E says " No new request provided"?

sna wrote: Thu Feb 03, 2022 12:00 pm If I enter same user(Column C) it shows existing request in column E as seen in the image below.

Not found the image in your post. Please attach the image again.

here is an image after test more on column c

...

E2

=IF(C2&D2=C1&D1,"No new request provided",IFERROR(LOOKUP(2,1/ISERROR(SEARCH(TRIM(MID(SUBSTITUTE(D2,",",REPT(" ",50)),(COLUMN($G2:$M2)-COLUMN($G2)+1)*50-49,50)),VLOOKUP(C2,$C$2:$D$11,2,0))),TRIM(MID(SUBSTITUTE(D2,",",REPT(" ",50)),(COLUMN($G2:$M2)-COLUMN($G2)+1)*50-49,50))),D2))

Norkaz