So, it translates like this?
Just to make sure I'm following.![]()
=IFERROR(INDEX(Range_to_Reference,AGGREGATE(smallest,ignoring_errors,(ROW(range_of_rows)-1)/(Within_RANGE-Greater_or_Less_Than"",ROW(From_rows-1to1))),"")
Also:
D18 Should be equivalent to something to the effect of
Where the Cells![]()
=IF(OR($D$10="","OptSelect"),INDIRECT("OptSelect"),$D$10)
D19,D20,D21 would be something like
I am sorry this is such a pain.![]()
=IF($D$18="OptSelect","",INDIRECT($D$18))
Bookmarks