View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David127
 
Posts: n/a
Default Create a list based on single shared criteria

An array or function is needed to create a list based on a single shared
criteria.

ID# Value Name
y1 5 Jill
x2 7 Jack
x3 3 Mary
y1 15 James
y1 9 Vito
z1 4 Wally


Based on the above table a list selecting ID# y1 would generate:

Jill
James
Vito

Thanks in advance!