Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy down an indirect formula
from reading this board I figured out how to use an indirect formula: here
is mine: =IF(INDIRECT("B2743")=INDIRECT("C2743"),1,0) what I need to do is copy this down through row 9902. I want it to change to row 2748, 2749, 2750 and so on. right now if I try to copy it down it remains exactly the same (row 2743). Any ideas?? These boards have been very helpful with advanced functions!!!! Thank you!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy down an indirect formula
Relate the reference row to the current row. For instance if the first
formula is in A1, you would use this =IF(INDIRECT("B"&ROW()+2742)=INDIRECT("C"&ROW()+27 42),1,0) When you copy this down the value of ROW() will change depending on the row the cell is in. You will need to change according to where the cell is. That being said, normally the INDIRECT function should be used when you DON'T want the reference to change as you copy the cells. If you want the references to change as you copy use a regular reference like =IF(B2743=C2743,1,0) "Joeb" wrote: from reading this board I figured out how to use an indirect formula: here is mine: =IF(INDIRECT("B2743")=INDIRECT("C2743"),1,0) what I need to do is copy this down through row 9902. I want it to change to row 2748, 2749, 2750 and so on. right now if I try to copy it down it remains exactly the same (row 2743). Any ideas?? These boards have been very helpful with advanced functions!!!! Thank you!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy down an indirect formula
If you are wanting it to change by row, why bother with INDIRECT?
-- HTH RP (remove nothere from the email address if mailing direct) "Joeb" wrote in message ... from reading this board I figured out how to use an indirect formula: here is mine: =IF(INDIRECT("B2743")=INDIRECT("C2743"),1,0) what I need to do is copy this down through row 9902. I want it to change to row 2748, 2749, 2750 and so on. right now if I try to copy it down it remains exactly the same (row 2743). Any ideas?? These boards have been very helpful with advanced functions!!!! Thank you!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy down an indirect formula
Ok thanks, I will give this a shot tomorrow.
I am using indirect because I am inserting many cells and shifting the rest down. I have to match up names but have different address's, so a query will not work. I started at 90k lines and narrowed it down to 10k rows with queries. I am turning them green when they match so I know that I have not missed any. Thanks again Joe "Bob Phillips" wrote: If you are wanting it to change by row, why bother with INDIRECT? -- HTH RP (remove nothere from the email address if mailing direct) "Joeb" wrote in message ... from reading this board I figured out how to use an indirect formula: here is mine: =IF(INDIRECT("B2743")=INDIRECT("C2743"),1,0) what I need to do is copy this down through row 9902. I want it to change to row 2748, 2749, 2750 and so on. right now if I try to copy it down it remains exactly the same (row 2743). Any ideas?? These boards have been very helpful with advanced functions!!!! Thank you!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Insert Formula and Copy to other cells | Excel Discussion (Misc queries) | |||
copy formula and get value instead | Excel Discussion (Misc queries) | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions |