|Just imagine how much more help we could be if you actually included the formula you are having problems with?|
You know what else would help? An example of your data so that we can see what the formula is working with.
Please read the How To referenced in my signature line before posting data.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.