Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare columns
Hi
I am trying to create a code in Vba to compare the text of 2 columns in Exel (for finding a list of words that are equal between the two) and create another column with the result .Can you help me? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare columns
For aguments lets suppose that the data to be compared are in columns A and
B - cells 1 to 10 respectively, and if they dont match fasle will appear in the corresponding row in column C. dim strA as string dim strB as string dim x as integer for x=1 to 10 strA=cells(x,1) strB=Celss(x,2) if strA<strB then cells(x,3).value = false next x "abulenta" wrote in message ... Hi I am trying to create a code in Vba to compare the text of 2 columns in Exel (for finding a list of words that are equal between the two) and create another column with the result .Can you help me? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare columns
yes it works but i need to compare each cell of the column B with each cell
of the column A, maybe i need to use the comand loop until ? "Graham Whitehead" wrote: For aguments lets suppose that the data to be compared are in columns A and B - cells 1 to 10 respectively, and if they dont match fasle will appear in the corresponding row in column C. dim strA as string dim strB as string dim x as integer for x=1 to 10 strA=cells(x,1) strB=Celss(x,2) if strA<strB then cells(x,3).value = false next x "abulenta" wrote in message ... Hi I am trying to create a code in Vba to compare the text of 2 columns in Exel (for finding a list of words that are equal between the two) and create another column with the result .Can you help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare Two columns | Excel Worksheet Functions | |||
Compare two columns | Excel Discussion (Misc queries) | |||
Compare Columns | Excel Discussion (Misc queries) | |||
Compare two columns | Excel Discussion (Misc queries) | |||
Compare all following columns when value is same | Excel Programming |