Hi Pete, in the above you have some mismatched () but that must be a typo here since as you say the calc runs. Why don't you mock up a bit of data and post a packaged workbook. I haven't done much filtering on extracts, so I'd be interested in working through that process. Thanks,
I resorted to correcting the data at the source table in MySQL, and created a script that cleanses it daily. Unfortunately the data is confidential, and not easy to share. Thanks for the offer though.
Pete, no problem. We responders are only looking for satisfied customers (well compatriots) -- hope you're one.