Last time I did something similar, albeit in a different context, I built the formula ie., place different parts of the formula in different cells and build the formula in one cell.
CONCATENATE ?
good luck
HDR
hardman resources limited
excel experts required, page-10
Add to My Watchlist
What is My Watchlist?