Show a list of plants requiring a minimum temperature

		Microsoft Office Forums > Microsoft Excel > Excel
Show a list of plants requiring a minimum temperature

FAQ

Thread Tools

Display Modes

11-09-2021, 08:41 AM

Pecoflyer

Windows 7 64bit Show a list of plants requiring a minimum temperature

Office 2010

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

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

Copy of Plants.xlsx (12.6 KB, 13 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
minimum charge	Trapshooter1956	Excel	2	03-14-2017 09:36 AM
Chart y-axis minimum, auto not working?	gebobs	Excel	0	03-24-2016 11:05 AM
What are the minimum margins most printers can handle?	20GT	Word	3	11-08-2014 10:40 PM
STDEV minimum number of points	littlepeaks	Excel	0	01-15-2012 06:40 PM
Word Minimum Margin	rangeshram	Word	0	09-24-2008 01:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:26 AM.