Copy date of a cell if a value is repetead.

[zargon]

I would appreciate your valuable help.

I have a sheet that contains a 3 columns every column contains a value A1:TOKEN, B1:CHIP & C1:DATE, the token value can be repetead any times but i need that if this ocurrs copy the same DATE of the first TOKEN that aparece.

For example:
[TABLE="width: 240"]
<tbody>[TR]
[TD="width: 80"]TOKEN[/TD]
[TD="width: 80"]CHIP[/TD]
[TD="width: 80"]DATE[/TD]
[/TR]
[TR]
[TD="align: right"]133[/TD]
[TD="align: right"]2995478[/TD]
[TD="class: xl63, align: right"]09/05/17[/TD]
[/TR]
[TR]
[TD="align: right"]133[/TD]
[TD="align: right"]2995479[/TD]
[TD="class: xl63, align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]133[/TD]
[TD="align: right"]2995480[/TD]
[TD="class: xl63, align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]134[/TD]
[TD="align: right"]2995481[/TD]
[TD="class: xl63, align: right"]10/05/17[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 240"]
<tbody>[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
RESULT:

[TABLE="width: 240"]
<tbody>[TR]
[TD="width: 80"]TOKEN[/TD]
[TD="width: 80"]CHIP[/TD]
[TD="width: 80"]DATE[/TD]
[/TR]
[TR]
[TD="align: right"]133[/TD]
[TD="align: right"]2995478[/TD]
[TD="class: xl63, align: right"]09/05/17[/TD]
[/TR]
[TR]
[TD="align: right"]133[/TD]
[TD="align: right"]2995479[/TD]
[TD="class: xl63, align: right"]09/05/17[/TD]
[/TR]
[TR]
[TD="align: right"]133[/TD]
[TD="align: right"]2995480[/TD]
[TD="class: xl63, align: right"]09/05/17[/TD]
[/TR]
[TR]
[TD="align: right"]134[/TD]
[TD="align: right"]2995481[/TD]
[TD="class: xl63, align: right"]10/05/17[/TD]
[/TR]
</tbody>[/TABLE]

 

[mole999]

You are requested to read and follow forum rules. I saw that you posted this entry three times in succession, and as a new member you like all others are subject to auto moderation. You should receive emails to the effect that your post will need review by a moderator before it will be displayed