Extract value from list by index # 1

[csjoseph]

How can I pull values from a list in order using formulas?

nameList(1)
nameList(2)
nameList(3)

I need to populate a #'d list from a name field.

Please help, db due Friday.

Thanks.

 

[pmonett]

Use the @Subset function. Extracting from the middle of a list is done by combining :

@subset(@subset(list,number_of_elements_to_the_one_you_want);-1)


Pascal.


I've got nothing to hide, and I'd very much like to keep that away from prying eyes.

 

[csjoseph]

pascal, you are the s!@%

Thanks again.