I am looking for a custom function that will get values based upon a list of value numbers.

 

Example:

 

Data = a¶b¶c¶d¶e¶f¶g

Value Numbers = 3¶5¶6

 

Result should be = c¶e¶f

 

Or if I can choose my own separator, that would be great.

 

Any help I can get would be greatly appreciated.

Have a look here: http://www.briandunning.com/cf/1118

Thank you for the reply.

 

That function does not get specific values. It gets every 2nd or 3rd or 4th and so on.

/*
GetValues ( listOfValues ; listOfNumbers )
*/


Let([
$i = $i + 1;
v = GetValue ( listOfValues ; GetValue ( listOfNumbers  ; $i  ) )
];
Case(
$i ≤ ValueCount ( listOfNumbers ) ; List ( v ; GetValues ( listOfValues ; listOfNumbers ) );
Let ( $i = "" ; "" )
)
)

Try something like:

 

GetValues ( listOfValues ; valueNumbers ) =

Let (
countValues = ValueCount ( valueNumbers )
;
GetValue ( listOfValues ; GetValue ( valueNumbers ; 1 ) )
&
Case ( countValues > 1 ; ¶ & GetValues ( listOfValues ; RightValues ( valueNumbers ; countValues - 1 ) ) )
)

To use your own separator, just substitute it with ¶ when calling the function, then reverse the substitution on the result.

@Nick

 

What should be the result if:

 

Data = a¶b¶c¶d¶e¶f¶g

Value Numbers = 8¶1¶2

 

?

 

If it shoud be:

a¶b than my CF is OK

else

If it shoud be:

¶a¶b than Comment's CF is OK

Raybaudi, I tried your function and it works perfectly. Thank you!