Thread: Automatically generate formulas from just the row numbers (auto insert the column)
View Single Post
 
Old 04-24-2017, 05:06 AM
knewman knewman is offline Windows XP Office 2007
Novice
  
Join Date: Apr 2011
Posts: 8
knewman is on a distinguished road
Default
You're a genius! I've been trying to get the suggestion from ExcelForm to work all evening and it just hasn't been working.

Ok so this is an example of one of the formulas:
=MAX((INDEX(FlakeLength,$AH2-1):INDEX(FlakeLength,$AI2-1)))

I noticed that you have split the data range info in my spreadsheet into two columns, and I see how that plugs into the above formula, but how does the formula know that this data range info relates to the 'Master Data' tab?
Reply With Quote