Hello,
I have two column of data colA and colB. data in colB includes 0 and other numbers. i would like to use a function on colC and colD that IF colB is bigger than 0 then insert the value of ColA in ColC and insert the value of colB in colD but I don't want to have any gaps between cells. Any ideas?
I have attached an axample file which what do I expect to get!
Thanks
Bookmarks