The values in Column C are repeating any solution for that

"Bernd P" wrote:

Hello,

If your values in column C are non-repeating and if they all exist in
column A:

Enter into E1:
=IF(C1<"",MATCH(C1,$A$1:$A$20000,0),"")

Enter into F1:
=IF(ISERROR(MATCH(ROW(),$E$1:$E$20000,0)),"",INDEX (C$1:C$20000,MATCH
(ROW(),$E$1:$E$20000,0)))

Copy F1 to G1.

Then copy E1:G1 down as far as necessary.

After recalculation you might want to copy values in F:G to C:D.

Regards,
Bernd