0

Cell Reference Last Column in Column Replicator

Jet Reports Historic Posts

August 25, 2014 19:10

None

Follow

I am using a replicator to push dates in columns.

It looks like this. =NL("Columns",NP("Dates",'Date Range'!C17,'Date Range'!C18,"Day","True"))

It is working as expected. I am just trying to find the last column to use a reference in another formula. However, since I do not know the last cell to reference because it could change. Any thoughts on how to catch the last column?

Thanks in advance

Pete

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts August 25, 2014 20:45

  I would probably try something like this, have my columns set up looking something like this in the first four rows:
  
  (C3) Full Report Start Date | (E3) First Period Start
  (C4) Full Report End Date | (E4) First Period End
  (C5) Full Report Date Filter | (E5) First Period Filter
  | (E6) =IF(E4=$C$4,"LAST","")
  
  Then, use the column with the "Last" tag in row 6 for my calculations.

• 0
  
  Jet Reports Historic Posts August 26, 2014 00:25

  Thanks. Got me headed in the right direction. I was able to use an Index/match to get me to the right point. I knew the date in the last column so I could match against it.

• 0
  
  Jet Reports Historic Posts August 26, 2014 11:44

  It looks like this. =NL("Columns",NP("Dates",'Date Range'!C17,'Date Range'!C18,"Day","True"))

  
  Using the same formula but with the first parameter Count will give you the number of columns that are generated.
  Using OFFSET you can calculate the reference to the last column.
  
  HTH
  
  rmw