Hi All,

im trying to drag down a formula, leaving a blank cell inbetween each entry. For simplicity sake i will simplify the formula im using.

Basically say in column A i have
1
2
3
4
5

In column B1 i have =A1 and in B3 i have =A2, if i drag down i get in cell B5 =A5 instead of A3 as i would like. If theres a way to get around this i would love to know as it is getting a little more than annoying at the moment. Also if anyone who does know and would like to apply their skills to the actual formula im using, that would be above and beyond. =TRIM(MID(SUBSTITUTE('Master Tracker Data'!$BA12,"##",REPT(" ",LEN('Master Tracker Data'!$BA12))),((COLUMNS('Master Tracker Data'!$BA12:BA12)-1)*LEN('Master Tracker Data'!$BA12))+1,LEN('Master Tracker Data'!$BA12)))

Please help me! thanks