Getting a list of returned values from an array

[ProfMarks]

Is there a function / method to get a list of returned text values from an
array with corresponding numerical or true/false values?

For example,
if I have an array such as:

1 apples
0 oranges
1 pineapple
0 strawberry

Is there a way to get a return value(s) that produces a list of:
apples
pineapples

If not, any work arounds would be helpful as well.

 

[Jim Cone]

How about sorting the list by the first column?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"ProfMarks"
wrote in message
Is there a function / method to get a list of returned text values from an
array with corresponding numerical or true/false values?

For example,
if I have an array such as:
1 apples
0 oranges
1 pineapple
0 strawberry
Is there a way to get a return value(s) that produces a list of:
apples
pineapples
If not, any work arounds would be helpful as well.