Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have a problem and I don't know how to solve it with chart functions.
Suppose that I have a field with this possible values:
John
Michael
Rose
Danny
Then I could use concat( {<Name=>} distinct [Name] ,',') to have the next value in a text field or function:
John,Michael,Rose,Danny
Well, I'm looking for a way to show the order of selected item over field Name in that list.
Examples:
If I select Jhon I want see 1
If I select Rose I want see 3
Does anybody knows how can I solve this?
Thanks
The match() function returns the number corresponding to a value in a list. You would write the function something like this:
=match(Name, $(=concat({<Name=>} distinct chr(39) & [Name] & chr(39), ',')))
OR
=match('Danny', $(=concat({<Name=>} distinct chr(39) & [Name] & chr(39), ',')))
The dollar sign expansion is needed around the concat() so that it just returns the list of values to search over.
The match() function returns the number corresponding to a value in a list. You would write the function something like this:
=match(Name, $(=concat({<Name=>} distinct chr(39) & [Name] & chr(39), ',')))
OR
=match('Danny', $(=concat({<Name=>} distinct chr(39) & [Name] & chr(39), ',')))
The dollar sign expansion is needed around the concat() so that it just returns the list of values to search over.
I doubt, whether it will return correct number. I am assume, For Rose Match returns 4 not 3. I haven't check may be it will return 4 only.
Or May be Data island table will work for this case
Thanks Nicole! It's fit for my solution