peterwmartin
02-29-2016, 10:13 PM
Hi all,
Please I need some help.
I have four columns, A & B are blank, C has numbers and words, D has a description if the column before it has a word.
What I am trying to do is if column C contains a word or string then move it and its description to column A & B.
I have tried if cell contains a word change its offset (0,-2) or remove the blanks by using special cells.
Nothing I am doing gets the desired result, any help or pointers would be appreciated.
Please I need some help.
I have four columns, A & B are blank, C has numbers and words, D has a description if the column before it has a word.
What I am trying to do is if column C contains a word or string then move it and its description to column A & B.
I have tried if cell contains a word change its offset (0,-2) or remove the blanks by using special cells.
Nothing I am doing gets the desired result, any help or pointers would be appreciated.