Thread: Show a list of plants requiring a minimum temperature
View Single Post
 
Old 11-11-2021, 09:03 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,780
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default
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
Reply With Quote