View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jay Somerset
 
Posts: n/a
Default Working with Sets ??

Are there any pre-defined workbook functions that deal with sets? For
example, finding if a particular value/token is member of a set (array or
selection), what values are present in the intersection or union of multiple
sets, etc.

These things can be done with the Find and Match functions together with
logical operators, but it messy.

TIA.
--
Jay.
(remove dashes for legal email address)