Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofill but with a custom rule??
Hi,
Is it possible to autofill with custom rules. Example: Cell A1 contains a row of IF functions with references to let's say C4, G4 and H4. If i autofill this normally A2 would contain the same IF functions but now with references to C5, G5 and H5 unless $ is used of course. My dilemma is that I want Excel to fill A2 with the same If function as A1 but with references now to C6, G6 and H6 and then when i autofill A3 I want it to contain the same IF function referring to C8, G8 and H8, so on and so forth. Since I paste data in to one sheet and then use another sheet to compile it this feature would be very helpful to me but I realize that it's unlikely that this is possible... still wanted to ask though. Regards Mitch |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofill but with a custom rule??
Yes it is, have a look at this formula:
=SUM(INDIRECT("G"&ROW(2:2)*2&":H"&ROW(2:2)*2))*IND IRECT("C"&ROW(2:2)*2) which is equal to =sum(G4:H4)*C4 but when copied down becomes =sum(G6:H6)*C6 and so on the trick is to use the INDIRECT and the ROW() functions. Hope this helps! JG "Mitch" wrote: Hi, Is it possible to autofill with custom rules. Example: Cell A1 contains a row of IF functions with references to let's say C4, G4 and H4. If i autofill this normally A2 would contain the same IF functions but now with references to C5, G5 and H5 unless $ is used of course. My dilemma is that I want Excel to fill A2 with the same If function as A1 but with references now to C6, G6 and H6 and then when i autofill A3 I want it to contain the same IF function referring to C8, G8 and H8, so on and so forth. Since I paste data in to one sheet and then use another sheet to compile it this feature would be very helpful to me but I realize that it's unlikely that this is possible... still wanted to ask though. Regards Mitch |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using custom functions within custom validation | Excel Discussion (Misc queries) | |||
make custom formatting permanent | Excel Worksheet Functions | |||
Can you link a custom property to an Excel custom header text? | Setting up and Configuration of Excel | |||
Custom charts - default formatting | Charts and Charting in Excel | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) |