View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jim jim is offline
external usenet poster
 
Posts: 1
Default combination lists

I've got 7 categories and each have two possible values, a and b. I'd
like an excel macro to list all the possible combinations in an array
for all the categories. I know there are 128, but I don't know how to
create and list all combinations. Anybody know how?