K
KH_GS
Hi All,
I need to match words within a column, for the first 3 columns.
I have the following code done, however, this will not work if there i
a blank row in between the list of words that I have in the column.
x = ActiveCell.Row
y = ActiveCell.Column
Do While Cells(x + 1, y - 2).Value <> ""
'to input EXACT formula
ActiveSheet.Cells(x, y).FormulaR1C1 = "=EXACT(RC[-1],R[1]C[-1])"
x = x + 1
Loop
I cannot sort columns 2 and 3 alphabetically because it will distor
the data in adjacent columns.
How can I go about matching the words down the column skipping blan
rows and check with the next non-blank cell
I need to match words within a column, for the first 3 columns.
I have the following code done, however, this will not work if there i
a blank row in between the list of words that I have in the column.
x = ActiveCell.Row
y = ActiveCell.Column
Do While Cells(x + 1, y - 2).Value <> ""
'to input EXACT formula
ActiveSheet.Cells(x, y).FormulaR1C1 = "=EXACT(RC[-1],R[1]C[-1])"
x = x + 1
Loop
I cannot sort columns 2 and 3 alphabetically because it will distor
the data in adjacent columns.
How can I go about matching the words down the column skipping blan
rows and check with the next non-blank cell