Can you zip and post a sample so we can try to replicate the problem. if you can try to post the bare minimum that it takes to demonstrate the problem. I'm guessing it's probably a syntax issue with the conditional logic in Excel, but I'd be happy to take a look at it.