Hi,
I have a cell which contains a number Off14ch and another cell just above this which contains Off14(Under column named "ID"). Like this i have multiple cells with numbers differing like 14,15,16 etc...I have to search for ch in the column and go to the previous row (which does not have ch) and copy the cell under comment column and append it to the cell under comment column of the row containing the ch.
I guess we have to make use of the fact that the row will be just above this ch.
Please see the attached sheet to understand my question better.
Thanks a lot in advance for help.
I would be greatful
Nida
Bookmarks