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:

TOKEN	CHIP	DATE
133	2995478	09/05/17
133	2995479
133	2995480
134	2995481	10/05/17

<tbody>
</tbody>

<tbody>
</tbody>

RESULT:

TOKEN	CHIP	DATE
133	2995478	09/05/17
133	2995479	09/05/17
133	2995480	09/05/17
134	2995481	10/05/17

<tbody>
</tbody>

 

[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