Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.misc




Copy the formula by dragging but down but calculate by going left
Hi,
If I enter the formula: =$C$1E75 and copy down by dragging the column will remain E and the rows will change to 76,77,78 etc. I need the opposite so when I drag down the row remains 75 but the column changes to F, G, H ... I hope that my request was clear. If that is possible please let me know. Thank you in advance. Regards, Frank Gashi CUNY 
#2
Posted to microsoft.public.excel.misc




Copy the formula by dragging but down but calculate by going left
Hi,
Am Thu, 13 Oct 2016 10:05:27 0700 (PDT) schrieb F.G.: If I enter the formula: =$C$1E75 and copy down by dragging the column will remain E and the rows will change to 76,77,78 etc. I need the opposite so when I drag down the row remains 75 but the column changes to F, G, H ... try: =$C$1INDEX($E$75:$XFD$75,,ROW(A1)) Regards Claus B.  Windows10 Office 2016 
#3
Posted to microsoft.public.excel.misc




Copy the formula by dragging but down but calculate by going left
On Thursday, October 13, 2016 at 1:28:35 PM UTC4, Claus Busch wrote:
Hi, Am Thu, 13 Oct 2016 10:05:27 0700 (PDT) schrieb F.G.: If I enter the formula: =$C$1E75 and copy down by dragging the column will remain E and the rows will change to 76,77,78 etc. I need the opposite so when I drag down the row remains 75 but the column changes to F, G, H ... try: =$C$1INDEX($E$75:$XFD$75,,ROW(A1)) Regards Claus B.  Windows10 Office 2016 AMAZING, It works, can you explain how the actual formula works. Thanks much my friend. Frank 
#4
Posted to microsoft.public.excel.misc




Copy the formula by dragging but down but calculate by going left
Hi Frank,
Am Thu, 13 Oct 2016 10:54:39 0700 (PDT) schrieb F.G.: It works, can you explain how the actual formula works. Row(A1) is the column of the INDEX and will be increased by one when you copy the formula down. Regards Claus B.  Windows10 Office 2016 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
What formula do I use to copy only text on left side of a comma?  Excel Worksheet Functions  
dragging formula down makes a copy  Excel Discussion (Misc queries)  
Excel VBCopy formula down until adjacent cell (left) is blank?  Excel Programming  
Excel VBCopy formula down until adjacent cell (left) is blank?  Excel Discussion (Misc queries)  
Copy formula relative to left cell?  Excel Programming 