Spreadsheet: 678929d1590131586-wanted-to-have-a-formula-that-has-a-dynamic-range-based-on-column-data-book1
Sheet: Sample

 | PCODE | Wk11 | Wk12 | Wk13 | Wk14 | Wk15 | Wk16 | Wk17 | Wk18 | Wk19
Labeling  Top 3 |  |  |  |  |  |  |  |  |  |  |  |  | I want the formula in B2,B3 and B4 that  has the range "K5:K49" to be dynamic  wherein it will become "L5:L49" if there  will be data in wk20 (or Column L) and so on.
%TOTAL | 911 | 0.02566576955350723 | No data | 0.01172395870433713 | 0.02279455726929444 | 0.01502391746408804 | 0.01770067383338364 | 0.01309393323404964 | 0.007282477090056605 | 0.01550129297006092
 | 915 | 0.03777995631909342 | 0.02179356225008683 | 0.02479616347512253 | 0.03472962972288566 | 0.02995659074878485 | 0.01992520878694871 | 0.02724525486737728 | 0.03140866573776822 | 0.03350131743650385
 | 920 | 0.06533329488811873 | 0.04760094361902983 | 0.03590525876772192 | 0.047568514367586 | 0.03173706205633972 | 0.03083860273554615 | 0.03370577797707358 | 0.03011314086057146 | 0.02952001949329477
 | 922 | 0.0364589626450771 | 0.03995719272857234 | 0.04208785258278254 | 0.03571211159350343 | 0.03705047842324596 | 0.03924304355893479 | 0.03872662044844086 | 0.02790613045587624 | 0.02569640429325393
 | 700 | 0.05085833225105765 | 0.0123845328432067 | 0.02609397316225278 | 0.04076706576088131 | 0.03200102459113188 | 0.007917394374775651 | 0.02070054775790833 | 0.0264668842403587 | 0.01885618223756112
 | 704 | 0.001629791463163308 | 0.004010448033298072 | 0.004211460911376332 | 0.002648179146362213 | 0.003402979092269583 | 0.003627006519898013 | 0.003618387136795472 | 0.003728164143050126 | 0.003017693091399229
 | 705 | 0.02017525904113203 | 0.004974357576093966 | No data | No data | 0.02079415683970726 | 0.01048169203656843 | 0.01094894297635594 | 0.004283018707834227 | 0.003316096048954473
 | 980 | 0.02821861871578609 | No data | No data | 0.01812905279340663 | 0.0225454278694884 | No data | 0.03346322103874677 | 0.02680093450766 | No data
 | 981 | 0.03477874623070784 | No data | 0.03451649663253183 | 0.03805115497549676 | 0.0225454278694884 | No data | 0.04889435009438639 | No data | No data
 | 976 | 0.02200409443953669 | 0.02522045473303818 | 0.01641175479747039 | 0.01830953561914211 | 0.01325509338518603 | 0.0107167443830961 | 0.01192220160518623 | 0.009483824434387802 | 0.01186443446307405
 | 300 | 0.01434439368437877 | 0.01525778979977499 | 0.01453289527183119 | 0.01514060069909179 | 0.007607268293908846 | 0.01579787753601853 | 0.01770795736001082 | 0.02043707261189347 | 0.01985212669192604
 | 400 | 0.0007177571111926405 | 0.001065757045206011 | 0.005238959377874516 | 0.004903150714541801 | 0.006438842177234403 | 0.004475454065771059 | 0.004425060103736362 | 0.005243255749794318 | 0.002350022831930466
 | 444 | No data | No data | No data | No data | 0.001602241835387296 | No data | No data | No data | No data
 | 800 | 0.04614977071174056 | 0.00922169619273881 | 0.01061797495359595 | 0.02832796894343143 | 0.02600459454283094 | 0.02456989337825374 | 0.01505825208424265 | 0.01339008267137764 | 0.01460302472627544
 | 805 | No data | No data | No data | No data | 0.001602241835387296 | No data | No data | No data | No data
 | 820 | 0.0021724098619234 | No data | No data | No data | No data | No data | No data | No data | No data
 | 830 | 0.02471801877288415 | 0.00872217470584551 | 0.01602553875469759 | 0.0186957981489021 | 0.01569147994263881 | 0.02051305911914581 | 0.02923286655868274 | 0.02919562927534405 | 0.01247325470216868
 | 811/431 | No data | No data | 0 | 0 | 0 | 0.0244864763047942 | 0.03734119028643374 | 0.0259583336438694 | 0.02104416039044565
 | 780 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 860 | 0.008642693985843844 | 0.005364861915771497 | 0.004676039476375202 | 0.00502779797003172 | 0.005244808904294008 | 0.005518031269431262 | 0.006347098876861778 | 0.004592275810491559 | 0.005171012202461713
 | 740 | 0.0249613890861816 | 0.02469395844562788 | 0.01446141976111724 | 0.03098885652286222 | 0.03394990553309452 | 0.02290098326982221 | 0.04311745037393849 | 0.04500612406147861 | 0.02717662281750049
 | 200 | 0.05295106911389871 | 0.03879756015070406 | 0.007051804790395902 | 0.03834586524107122 | 0.04221006718710345 | 0.05447720594098941 | 0.0539383158529533 | 0.02838782627569856 | 0.06142737308149647
 | 210 | No data | 0.08555904799074804 | 0.07434245669843918 | 0.07419753749225733 | 0.06426980742011758 | 0.07354099460362155 | 0.07322961553478415 | 0.05640792118321546 | 0.05708016821997372
 | 310 | 0.01923229072746876 | 0.01128886366908307 | No data | No data | No data | No data | No data | No data | 0.02074128543303662
 | 324 | 0.07707931384200303 | 0.04674774397718787 | No data | No data | No data | No data | No data | No data | 0.03248695017332662
 | 115 | 0.01296772136319882 | 0.009203511470842442 | 0.006220153235081717 | 0.00367095737212464 | 0.009015988750633037 | 0.00765278898691643 | 0.005835443141824384 | 0.007950923468749739 | 0.009454882315446519
 | 220 | 0.01286342013767713 | 0.01296285651997727 | 0.01636427586035652 | 0.02006361648963137 | 0.03094292642117906 | 0.02055318634998759 | 0.01954011177499801 | 0.02567637185137363 | 0.02094051802805275
 | 230 | 0.005057863940345373 | 1.65990355909012e-05 | 4.927657962140024e-06 | 8.647625749934349e-06 | 2.799365405262244e-06 | 1.479399870959185e-06 | 4.660779481045253e-06 | 2.518646269225758e-06 | 0.0005388663794339952
 | 241 | 0.01671703922740344 | 0.0222946608958606 | 0.01355873285247929 | 0.02072305235161369 | 0.02904378963973918 | 0.03133120207757366 | 0.02885617126348958 | 0.03481868094761276 | 0.02970122909846716
 | 242 | 0.004530736953886066 | 0.002693816300262858 | 0.00310110631753781 | 0.004484249913408947 | 0.005273463057375513 | 0.006886924359764845 | 0.007270946582846109 | 0.01145432866394114 | 0.01736832493653318
 | 244 | 0.01023107907881708 | 0.002806805263973165 | 0.002485412157601093 | 0.002937126315540595 | 0.003561774932311839 | 0.003385750179933342 | 0.002751841390062657 | 0.003382842919854604 | 0.003976437092138542
 | 250 | 0.01851700660678152 | 0.014875190007233 | 0.02256975418115438 | 0.01964343387091078 | 0.02439851296174569 | 0.03381964130844722 | 0.0325119175012805 | 0.02517711348905068 | 0.02234629257730474
 | 260 | 0.02577846364253326 | 0.02833725022729996 | 0.02473716263523718 | 0.02567252259467127 | 0.03033730337623793 | 0.02686971672690416 | 0.02809444259347672 | 0.03450433271700958 | 0.03488772041701471
 | 330 | 0.020584709447054 | 0.01154083302459083 | 0.006822141473931331 | 0.01190124200432841 | 0.0004938981159885364 | No data | No data | No data | No data
 | 340 | 0.01271718895485554 | 0.009204471834223323 | 0.01382352599333207 | 0.0142936886896462 | 0.01608828148491575 | 0.007180660152148994 | 0.009378894210224952 | 0.01088382888846556 | 0.01278011672278966
 | 350 | 0.005496697495903782 | 0.004378021624817564 | 0.007661235480478454 | 0.009736675757034557 | 0.01663619254834704 | 0.01975553018034836 | 0.02213336359541198 | 0.01662299529808122 | 0.01611969104313052
 | 370 | 0.01261595808666714 | 0.006937875291138693 | 0.003520346621481449 | 0.01126055581726816 | 0.01835968815172677 | 0.01526290481780136 | 0.0204229267287193 | 0.02577385140517854 | 0.02414625868856095
 | 110 | 0.004087096754781438 | 0.001674860654439879 | 0.0004180777254830373 | 0.0004583553470843571 | 0.0005847017957814523 | 0.0004715936412289138 | No data | 0.01279380531894173 | 0.005672569975485116
 | 118 | No data | 0.048011099938495 | 0.03117080029705686 | 0.04523631502236949 | 0.03120402044464756 | 0.02396926436121102 | No data | 0.02171882404091326 | 0.02420501378588194
 | 119 | No data | 0.02407866802591762 | 0.02432088140170681 | 0.02265349675698254 | 0.02227493246222802 | 0.01163170048002222 | No data | 0.00850053796891432 | 0.008917355193988324
 | 120 | 0.01666412973400948 | 0.008432670395090807 | 0.005925863111819319 | 0.005459618279983491 | 0.005905480382640506 | 0.009565215121527616 | 0.001926410887316165 | 0.005227403194903176 | 0.005288661378117958
 | 995 | 0.04065845730044851 | 0.01864359213659141 | 0.01428135278199862 | 0.02386544331658244 | 0.02322323664376221 | 0.02636863800931433 | 0.02265941974768276 | 0.01413878028434501 | 0.01203241830748172
 | 997 | 0.0951883187993769 | 0.04417288242989507 | 0.08553180686422313 | 0.1281584046585149 | 0.1233108274064311 | 0.09632219034041592 | 0.09637379091784917 | 0.0695261475597114 | 0.07446526411319672
 | 150 | 0.02206513295658703 | 0.02505196225758821 | 0.01767387259770537 | 0.01448644335973306 | 0.0142030324916917 | 0.01633777537908694 | 0.01198799756589378 | 0.008816171023655967 | 0.00536676868758681
 | 151 | 0.01085006231032134 | 0.01040217718388119 | 0.009206082889254792 | 0.006774696781824448 | 0.009335888132836558 | 0.008668206277443004 | 0.01931491039740686 | 0.01625623133056441 | 0.02407696526736727