Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed with this formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed with this formula
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed with this formula
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Help Needed | Excel Discussion (Misc queries) | |||
Formula needed | Excel Discussion (Misc queries) | |||
More Help Needed with Count formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula needed | Excel Worksheet Functions |