- Registration date
- Sunday June 14, 2009
- Last seen
- July 30, 2015
select H6. copy(control+c).
without removing selection cllick "pastevealues"
Then go on to the next row, I also want it to ignore blank cells and leave the formula there.
this is not clear
do you mena to say that when j of a row i1 then corresponding cell in H column should be values not formulas. if 0 keep the formula. clairfy