The wonderful thing about Excel's LOOKUP function, the semantics of which Google Sheets copies, is that if its 1st argument is a range or array, it'll evaluate the array, returning a same-size array of each 1st argument's items' lookup results based on the other arguments.
As this formula is going to be about 100 nested ifs, and added to each cell, i'm leaving this unsolved as a more scalable solution would be amazing, as this solution is a temporary fix and not that sustainable. Please see the below link for my solution. It's going to have to allow for about 100 different texts with varying counts, so its going to be a hefty formula. Anyone able to help?ĮDIT: to caveat i'm using google sheets not excel, so VBA is a no go, unless someone here is fluent in google scripts language? Additionally, to function would ideally just display items as an array in a single column, instead of a script that actually duplicates the rows.ĮDIT PART DEUX!: I've found out a way to do this, not using an array formula, but a cheeky if statement. I know this is a tricky one, I've searched the sub but can't find anything. I'm trying to create an array that automatically populates rows with a set of text, based on a cells numerical value of how many rows the text should be displayed. My first post here, I'm currently stuck with a function. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.
0 kommentar(er)
