tag:blogger.com,1999:blog-8807805591547673516.post6838551262179794701..comments2024-02-28T08:14:50.756-08:00Comments on Cloud Computing -- Google Docs Way: yogi_Create A MasterList of All Active Jobs From All Of The Yearly ListsYogi Anandhttp://www.blogger.com/profile/10862524957172908621noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8807805591547673516.post-8699309922487460092013-03-20T08:03:55.093-07:002013-03-20T08:03:55.093-07:00Amazing Yogi, thank you for the help it works perf...Amazing Yogi, thank you for the help it works perfectly. I think I am getting a better grasp of the "how" in this the only thing I I dont understand in the function (=query(vmerge('2012'!A2:E;'2013'!A3:E;'2014'!A3:E);"select Col1,Col2,Col3,Col4 where upper(Col5)='IN PROGRESS' ")) is the use of upper, what does that denote. Thanks again for your invaluable help.Anonymoushttps://www.blogger.com/profile/01498322561220920898noreply@blogger.com