Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm looking for a solution to the following problem:
I need a counter that counts up within the result of the repeat(...) function.
As an example:
=repeat( X, 5 ) should return '12345' as the result.
What can X look like for this?
Best regards
look at Valueloop function:
Concat(distinct ValueLoop(1, 10),'',ValueLoop(1, 10))
Hi,
here the complete solution:
look at Valueloop function:
Concat(distinct ValueLoop(1, 10),'',ValueLoop(1, 10))
Thank you for your reply.
Unfortunately, it doesn't quite solve the problem.
I need to concretize it.
X is a combination of text and consecutive number, so the result should be the following:
'abc1', 'abc2', 'abc3', 'abc4', 'abc5'
or more precisely, the result should be as follows:
'abc1 xyz1', 'abc2 xyz2', 'abc3 xyz3', 'abc4 xyz4', 'abc5 xyz5'
I need the number twice per repetition
Hi,
here the complete solution: