Hi
1 - Does the expression always consist of some terms separated by commas?
I control this, I think I'll use a "/" forward slash instead of a comma. It will be consistant
2 - What's the minimum and maximum number of terms in the expression?
It's percentage of a person's time when supporting multiple jobs. I think 25% increments would be good enough, but I have done 10% and 90% in the past. Maybe I just limit it to 25% increments to make the problem easier.
3 - Are the possible total results a small set of values or can they be anything? (For ex. 0 to 1 in increments of .05)
See above.
4 - Can you use vba?
I can, and am currently using VBA on the spreadsheet now for many other aspects. But, this issue is really on the "simplier" portion of the spreadsheet which is just data entry of people's time.
5 - What's your excel version?
2010
6 - Is each term in the expression always a number followed by just 1 letter? any letter?
Again, I'm choosing this syntax. # followed by A,B,C, or D
7 - Does the number at the beginning each term in the expression always start with a "."? If not which are the possible formats?
Yes, always fractions of 1 person
Well, these are just some things that crossed my mind, when I read your post.
It's not possible to know if there is a solution if one does not understand the problem.
If you can answer those questions and add anything else you deem relevant I'll give it a try tomorrow.
Nighty night!