Advanced Fill Series

TWN416

New Member
Joined
Apr 27, 2017
Messages
1
I am trying to auto-fill down same formula with only reference changing to cell T3. However, all other references increment +1. How can I keep all references constant while only incrementing T3 cell +1? (T4, T5, T6...).




<style type="text/css"> p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000} span.s1 {color: #0057d6} span.s2 {color: #006107} span.s3 {color: #ab30d6} span.s4 {color: #a54a29} </style>=INDEX(E4:E10,MATCH(T3,E4:E10,1))+INDEX(D4:D10,MATCH(T3,E4:E10,1))+(($T$3-INDEX(E4:E10,MATCH(T3,E4:E10,1)))/(1-INDEX(B4:B10,MATCH(T3,E4:E10,1)+1)))
 

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,317
Welcome to Mr Excel

Use Absolute References in all ranges, for example $E$4:$E$10, $D$4:$D$10 etc, less in T3

M.
 

Forum statistics

Threads
1,081,523
Messages
5,359,263
Members
400,523
Latest member
ExcelNewbie98

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top