Hi

I need to copy this formula down column B1 to B10546 and yet =Q1 must change
only to correspond to each row, Q2,Q3,etc.

I need Q1:Q$10546 and B1 to B10546 to stay the same

Hope I've been clear.

{=MCONCAT(IF(Q1:Q$10546=Q1,MOD(B1:B$10546,10),"")) }

Microsoft Excel 2002

Thanks in advance

Dave