Forum Discussion
ANY HELP APPRECIATED, MULTIPLE QUESTIONS
This will be a lot, if you can answer any of my questions please do. The spreadsheet I'm referring to is in the files section below. (this will be multiple parts, as there seem to be too many charact...
Nevermind on this part, I got it figured out! Also, disregard the "this will be multiple parts," as i managed to submit the question above in its entirety 😄
HansVogelaar I edited the formula mentioned above that you provided, but now I'm getting an error if the number of factors doesn't fit perfectly in the resulting area. The formula now says =LET(Num, ABS(XLOOKUP(TRUE,B1:G1<>"",B1:G1,,,-1)), All, SEQUENCE(, Num), Factors, FILTER(All, MOD(Num, All)=0), WRAPROWS(Factors, 3)) if that helps.
You can add an argument to WRAPROWS:
=LET(Num, ABS(XLOOKUP(TRUE,B1:G1<>"",B1:G1,,,-1)), All, SEQUENCE(, Num), Factors, FILTER(All, MOD(Num, All)=0), WRAPROWS(Factors, 3, ""))
The formula will now leave the unused cells blank instead of returning #N/A in them.
