Thread: Show a list of plants requiring a minimum temperature
View Single Post
 
Old 11-09-2021, 08:41 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
You could also use a simple Pivot Table, and filter the row labels as required, no complicated formulas needed
In XL 365 the FILTER function is also available
And your formula should be
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 with Ctrl+Shift+Enter and pulled down
Attached Files
File Type: xlsx Copy of Plants.xlsx (12.6 KB, 13 views)
Reply With Quote