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" 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
>
>
>
>

[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



"Suresh" <Suresh@discussions.microsoft.com> wrote in message
news:74A643ED-1869-4F29-913F-30D189A8CE70@microsoft.com...
> 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
>>
>>
>>
>>