Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find duplicates | Excel Worksheet Functions | |||
Find duplicates | Excel Discussion (Misc queries) | |||
Please help with a "find duplicates" macro - 4/10/07 | Excel Worksheet Functions | |||
Find Duplicates | Excel Discussion (Misc queries) | |||
Find duplicates | Excel Discussion (Misc queries) |