I would like to check the text in the first column of a named range.
If Text in the cell above = current selected cell then, add a formula to
(same Row, column D) where that formula would take the value of the cell above.
Something like: (Row, col D) = (Row -1, col D)
I believe a For loop is required. I just don't know how to cycle through the cells in Col A
and then put the formula in Col D.
Thanks for any help!
Bookmarks