LinkBack URL
About LinkBacks
I have Column G that has some cells that are missing text. I would like Column G to replace an cells that have are missing text with the text from Column C in that respective row. Is that easy to do?
I have Column G that has some cells that are missing text. I would like Column G to replace an cells that have are missing text with the text from Column C in that respective row. Is that easy to do?
Last edited by Will D; 10-13-2011 at 11:06 AM.
could you attach a sample with what you have and what your result should be?
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Column C
Row 1- Abc
2- Def
3- Ghi
4- Jkl
5- Mno
6- Pqr
7- Stu
8- Vwx
9- Yz
Column G
Row 1- Ab
2-
3- G
4- Jk
5-
6- Pq
7-
8- V
9-
Results (in red):
Column G
Row 1- Ab
2- Def
3- G
4- Jk
5- Mno
6- Pq
7- Stu
8- V
9- Yz
Does that make sense? If a cell in Column G is empty, then it needs to be replaced with the text in Column C from the respective row in Column C.
You need to temporarily add a helper column with a formula.
E.g. =IF(G2="",C2,G2)
copied down.
Then you can copy this column, go to column G and Paste Special | Values over column G.
Then delete the helper column.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
NBVC, you just beat me... I was going to post the same thing.
I don't quite understand what to do. Is it possible to add 1 formula to an entire column? Or do I need to add a formula to each row?
You add it once in in row 2, then copy the formula down. You click and drag the little black square at the bottom right corner of the cell with formula.
Incredible. It worked. Can you explain the formula so that I will understand it in the future?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks