Oh Paul... I am a complete nincompoop. I did not see you attached a Word Doc with this formula in it in your first response to me!!!! I only saw the link you included in that message. So Sorry! I would like to blame this mistake on the fact this is my first post to this forum, but I should have seen it as I have been on other forums such as excel.
The formula you have is great and works just as I was hoping. I have one more question. If I want to change the number of pieces in the set from 4 to 5, but reference another combo field, is this possible? I tried to change the formula to reference the new field I created but I got an error. See attached updated Word Doc.
Thanks in advance.
|