View Single Post
 
Old 11-11-2021, 10:07 AM
silverman166 silverman166 is offline Windows 10 Office 2007
Advanced Beginner
 
Join Date: Nov 2019
Posts: 31
silverman166 is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
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!
Reply With Quote