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
- Forums
- ASX - By Stock
- HDR
- excel experts required
HDR
hardman resources limited