The latest articles on DEV Community by Jirawat Sukpanthong (@jirawat_208). https://dev.to/jirawat_208 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F1863829%2Fde43ecc8-bcc9-4740-a7da-e1b5d539d601.jpg https://dev.to/jirawat_208 en Jirawat Sukpanthong Tue, 30 Jul 2024 19:43:03 +0000 https://dev.to/jirawat_208/answer-kaaraangingechllsuutrkhng-google-sheet-50im https://dev.to/jirawat_208/answer-kaaraangingechllsuutrkhng-google-sheet-50im <div class="ltag__stackexchange--container"> <div class="ltag__stackexchange--title-container"> <div class="ltag__stackexchange--title"> <div class="ltag__stackexchange--header"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--AoTUKOcU--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_800/https://dev.to/assets/stackoverflow-logo-b42691ae545e4810b105ee957979a853a696085e67e43ee14c5699cf3e890fb4.svg" alt=""> <a href="https://stackoverflow.com/questions/78805449/google-sheet-formula-cell-referencing/78805492#78805492" rel="noopener noreferrer"> <span class="title-flare">answer</span> re: Google sheet Formula cell referencing </a> </div> <div class="ltag__stackexchange--post-metadata"> <span>Jul 29 '24</span> </div> </div> <a class="ltag__stackexchange--score-container" href="https://stackoverflow.com/questions/78805449/google-sheet-formula-cell-referencing/78805492#78805492" rel="noopener noreferrer"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--oeieW07A--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_800/https://dev.to/assets/stackexchange-arrow-up-eff2e2849e67d156181d258e38802c0b57fa011f74164a7f97675ca3b6ab756b.svg" alt=""> <div class="ltag__stackexchange--score-number"> 0 </div> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--h2-sXgSn--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_800/https://dev.to/assets/stackexchange-arrow-down-4349fac0dd932d284fab7e4dd9846f19a3710558efde0d2dfd05897f3eeb9aba.svg" alt=""> </a> </div> <div class="ltag__stackexchange--body"> <p>Here's a possible solution. It only uses the numbers in column A.</p> <pre class="lang-cpp prettyprint-override"><code>=ARRAYFORMULA(LET( n,TOCOL(A2:A,1) MAP({"A"&amp;n,"C"&amp;n,"B"&amp;n+1,"B"&amp;n+2,"B"&amp;n+3,"B"&amp;n+4, "D"&amp;n+1,"D"&amp;n+2,"D"&amp;n+3,"D"&amp;n+4,"B"&amp;n+9,"B"&amp;n+10, "B"&amp;n+11,"B"&amp;n+12,"D"&amp;n+9,"D"&amp;n+10,"D"&amp;n+11,"D"&amp;n+12}, LAMBDA(c,LET(x,INDIRECT("'NEW BUNDLES CONTROL IN PROGRESS'!"&amp;c), IF(x="",,IF(LEFT(c)="A",REGEXEXTRACT(x,"\d+"),x))))))) </code></pre> <p>You can use this formula that doesn't use column A. The formula automatically generates the correct sequence of numbers based on where "BUNDLE NO. #" appears on…</p> </div> <div class="ltag__stackexchange--btn--container"> <a href="https://stackoverflow.com/questions/78805449/google-sheet-formula-cell-referencing/78805492#78805492" class="ltag__stackexchange--btn" rel="noopener noreferrer">Open Full Answer</a> </div> </div>