View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave
 
Posts: n/a
Default Do the values in a range of cells include all members of a set?

Suppose I'm assigning basebal positions with the set of strings, P, C, 1, 2,
3, SS, LF, CF, RF. After I've entered the 9 assignments, I want an
indication that I have covered all 9 positions. I can have 9 nested if/match
functions, but it seems like there should be a better way.