Help needed with this formula

[Dave 2005]

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

 

[Suresh]

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]

Thanks Suresh for your reply

You have made me understand where to put the $ sign, which is something like
this.

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

Thanks Suresh

Dave