"jlclyde" wrote:

On Feb 3, 9:39 am, Emece wrote:
Hi, I have a worksheet that has the following structure

A B
1 2 345
2 1 345
3 1 512

In column B there are values, and in column A there is a number that
indicates if the value in column B is repeated. In case it is repeated, I
want a macro that display in column C the result of multiplying that value
*2. Following the example I just wrote, I would need the value 690 displayed
in column C.

Hope it is clear enough

Thanks in advance

Regards,
Emece.-

Why use a macro?
You could just as easily use an If .

in C1 =IF(B1=B2,B1*2,"") This will multiply each duplicate by 2.
Just drag down to other cells.

Jay

Perhaps I didn't express myself correctly. I have several values in column B,
and values that are duplicated not necessarily are in adjacent rows. So, I
need to check the entire column and find duplicated values. Also, if the
value is duplicated, after doing 345+345, I need to delete one of both value.
Hope now it is clear enough.

Thanks again