Quote:
Originally Posted by Pecoflyer
My bad try
Code:
=INDEX($A$3:$A$9,SMALL(IF($D$3<=$B$3:$B$9,ROW($A$3:$A$9)-ROW($A$3)+1),ROW(1:1)))
committed as an array formula with CSE
|
OK that works better, but only returns one result even when there are more instances in the list, so not quite what I'm after.
I very much appreciate your time, but would not wish you to spend more time on it, unless you really want to, as the Filter option you also suggested, and is detailed in another post, works OK for me.
Many Thanks!