Quote Originally Posted by the_nibs View Post
Tony, thank you so much for taking the time to explain that. I know it probably took you a while to type that.
Yes, it did. I'm a one finger typer!

I think I follow everything up until the '-COLUMN($B3)+1' - why not simply subtract 1 i.e. 1/($B3:$E3<>"")*COLUMN($B3:$E3)-1 as we know the absolute position (column b = 2) is always 1 greater than the relative position of the first cell so column b = 2-1 = 1, c = 3-1 = 2, etc.
Not necessarily. Make the data range F5:I5 with 1/($F5:$I5<>"")*COLUMN($F5:$I5)-1

See what results you get.

oh, i see. the columns($G3:G3) is acting as the constant for the k-th smallest number for the aggregate function
Yes!