ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Working with Sets ?? (https://www.excelbanter.com/excel-discussion-misc-queries/57871-working-sets.html)

Jay Somerset

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)


All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com