I have a List ( value ) and my results are like this:
How can I extract first and last Results?
Desired output (either by original List(value) or secondary calc)
Result 1 & " - " & Result 4
Or more generically:
GetValue ( myList ; 1 )
& " - " &
GetValue ( myList ; ValueCount ( myList ) )
GetValue ( myList ; 1 ) & " - " & GetValue ( myList ; 4 )
Small change to Mike's solution. If you do not know how many items are going to be in your list:
GetValue ( myList ; 1 ) & " - " & GetValue ( myList ; ValueCount( myList ) )
erolst is on the case already.
Thanks for the reply! The only problem is that my results might be longer than 4.
Result 1 - Here
Result 4 - Here
Result 5 - Here
Result 6 - Here
Yes, this works, thanks guys!
Could you please reassign the correct answer to Mike_Mitchell who gave the first correct answer or erolst
who gave the first full answer? I promise, I will type faster next time
Welcome back erolst!! Long time no type
Retrieving data ...