tag:blogger.com,1999:blog-8807805591547673516.post7943460726540356003..comments2024-02-28T08:14:50.756-08:00Comments on Cloud Computing -- Google Docs Way: yogi_Merge Data From Several Sheets And Extract Only Non-Blank RowsYogi Anandhttp://www.blogger.com/profile/10862524957172908621noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8807805591547673516.post-78698132190242349762012-03-21T07:37:59.893-07:002012-03-21T07:37:59.893-07:00Hi ween:
I have shared the following spreadsheet ...Hi ween:<br /><br />I have shared the following spreadsheet <br />yogi_Merge Data From Several Sheets And Extract Only Non-Blank Rows<br />https://docs.google.com/spreadsheet/ccc?key=0AkHBcyclu11AdHZHelJ1bURReVJMUGFqSGQ1Y2VESlE#gid=22<br />with you for VIEWing -- the formula of interest is in sheet yogi_Test.<br /><br />I hope this helps.<br /><br />Cheers!<br />YogiYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-60572287940144643682012-03-20T10:51:08.095-07:002012-03-20T10:51:08.095-07:00i've this
iferror(if(column(A:CH),query(index(...i've this<br />iferror(if(column(A:CH),query(index(if(split(concatenate(column(A:CH)&char(9)),vmerge(SH!A10 :CH ;SH2!A10 :CH ;SH3!A10 :CH ;’RERANGE SH4’!A10 :CH),mmult(if(column(A:CH),len(vmerge(SH1!A10:CH;SH2!A10:CH;SH3!A10:CH;’RERANGE SH4!A10:CH))),transpose(column(A:CH)^0)))),’’select* where Col87>0’’)))<br />but maybe i copied badly the formula i've a macbook that's the problem with some symbol when i copy themweenhttps://www.blogger.com/profile/11225642742043317712noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-22816678837345474632012-03-20T10:35:33.413-07:002012-03-20T10:35:33.413-07:00but i can't copy your formula :( could you put...but i can't copy your formula :( could you put in on the online google document ?)<br />Where did you learn all this ? Is there a tutoral to understand how to formulate this ?<br /><br />Many regards, <br /><br />Weenweenhttps://www.blogger.com/profile/11225642742043317712noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-57545050328202459152012-03-20T10:34:17.086-07:002012-03-20T10:34:17.086-07:00Yogia you're really incredible, you're rig...Yogia you're really incredible, you're right my formula was crazy and not logical face to yours. I just love it;)<br />Congratulations <br /><br />Weenweenhttps://www.blogger.com/profile/11225642742043317712noreply@blogger.com