Hi Dave
I am not very sure if I understood your problem. The solution is to put a $
sign next to B1 as $B$1 which will keep it fixed wherever you copy the
formula. The =Q1 without the $ sign is a floating reference and will change
across the rows as you copy the whole column

"Dave 2005" wrote:

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