Macro to find duplicates
 

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.-

Macro to find duplicates
 

If you want to multiply only those values which are duplicate (a 2 in Col A)
then use this in C1 and copy down
=IF(A1=2,B1*A1,"")

If you want to multiple all values then simply use
=B1*A1

If you want to multiply all values greater than 1 then use
=IF(A11,B1*A1,"")

What is your ultimate purpose in doing this?

"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.-

Macro to find duplicates
 

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

Macro to find duplicates
 

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

"Sheeloo" wrote:

If you want to multiply only those values which are duplicate (a 2 in Col A)
then use this in C1 and copy down
=IF(A1=2,B1*A1,"")

If you want to multiple all values then simply use
=B1*A1

If you want to multiply all values greater than 1 then use
=IF(A11,B1*A1,"")

What is your ultimate purpose in doing this?

"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.-

Macro to find duplicates
 

"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