FEATURE REQUEST: Add Conditional RANGETOSTRING to return only certain values in the data set
The RANGETOSTRING function can return a list of values either horizontally or vertically and be offset to look in a different column or row. But, it cannot evaluate certain cells in the range and return only conditional values from an offset range as far as I know. I did find a way to do this in Excel but cannot get it to function in Microvellum.
Using a combination of an IF statement that returns an array with blanks in the cells that do not meet the criteria and TEXTJOIN which evaluates the array, returns values that are not blank and separates them with a delimiter I was able to get what I needed.
The attachment shows an small table with these functions applied and an example of some of the larger tables I'm trying to evaluate (There are about 40 tables and these are the smallest). If anyone has some Microvellum friendly ideas on how to make this work without tons of nested IF statements it would be very helpful.
MVU eLearning
Grow Your Knowledge
Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.