Show a list of plants requiring a minimum temperature

Pecoflyer · #1 11-12-2021, 12:33 AM

As you can see in the attached, this formula works perfectly.Did you commit with CSE?

silverman166 · #2 11-12-2021, 02:31 AM

Quote:

Originally Posted by Pecoflyer

As you can see in the attached, this formula works perfectly.Did you commit with CSE?

Thanks for replying to my last post, and Yes that works fine..........BUT it is not the same formula you sent me in the last post! This one starts with IFERROR... whereas the previous one didn't, but thanks to your persistence I now have the choice of two methods!

I am pleased with that result and think maybe I'll go with this one.

And the bonus is that I've learned quite a bit, too!

So thanks again.

silverman166 · #3 11-12-2021, 03:13 AM

Further to your last post, and my reply, I've just found that when I post the latest formula into my original spreadsheet, it still does not work as shown in the sample spreadsheet posted, which appears to show a Pivot table, the concept of which I'm not familiar.

I've attached it to demonstrate.

Very confused now!

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