This content originally appeared on DEV Community and was authored by Jirawat Sukpanthong
Here's a possible solution. It only uses the numbers in column A.
=ARRAYFORMULA(LET(
n,TOCOL(A2:A,1)
MAP({"A"&n,"C"&n,"B"&n+1,"B"&n+2,"B"&n+3,"B"&n+4,
"D"&n+1,"D"&n+2,"D"&n+3,"D"&n+4,"B"&n+9,"B"&n+10,
"B"&n+11,"B"&n+12,"D"&n+9,"D"&n+10,"D"&n+11,"D"&n+12},
LAMBDA(c,LET(x,INDIRECT("'NEW BUNDLES CONTROL IN PROGRESS'!"&c),
IF(x="",,IF(LEFT(c)="A",REGEXEXTRACT(x,"\d+"),x)))))))
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…
This content originally appeared on DEV Community and was authored by Jirawat Sukpanthong
Jirawat Sukpanthong | Sciencx (2024-07-30T19:43:03+00:00) Answer: การอ้างอิงเซลล์สูตรของ Google Sheet. Retrieved from https://www.scien.cx/2024/07/30/answer-%e0%b8%81%e0%b8%b2%e0%b8%a3%e0%b8%ad%e0%b9%89%e0%b8%b2%e0%b8%87%e0%b8%ad%e0%b8%b4%e0%b8%87%e0%b9%80%e0%b8%8b%e0%b8%a5%e0%b8%a5%e0%b9%8c%e0%b8%aa%e0%b8%b9%e0%b8%95%e0%b8%a3%e0%b8%82%e0%b8%ad/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.