View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hfazal hfazal is offline
external usenet poster
 
Posts: 22
Default How do you create a Set on Excel?

Here's what I'd like to do:

I'm planning on using the same file on several different tables, that all
have the same data but may have the different columns labelled differently:

Find Column that has the Rate
Assign Column with Rate as RatesColumn

The column with the Rate will be the column with a label in this set: (rate,
level, %, repo)

How can I create a Set of some sort which I can then use when running Find
and just say, if value is in Set then its True.