Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 11-12-2021, 07:48 AM
silverman166 silverman166 is offline Show a list of plants requiring a minimum temperature Windows 10 Show a list of plants requiring a minimum temperature Office 2007
Novice
Show a list of plants requiring a minimum temperature
 
Join Date: Nov 2019
Posts: 27
silverman166 is on a distinguished road
Default

Thanks for your explanations, but it still does not work.




Sorry, it seems I omitted to attach the sheet showing my problem in my last post, in which the selected value was not<5, but just 5.


Here it is.


What is going wrong for me?!!


Sounds like I'm also going to have to look into Pivot tables - thanks for the link, and your patience in this problem.
Attached Files
File Type: xlsx Plants Iferror solution.xlsx (8.9 KB, 2 views)
Reply With Quote
  #17  
Old 11-12-2021, 08:09 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Show a list of plants requiring a minimum temperature Windows 7 64bit Show a list of plants requiring a minimum temperature Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,569
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

There is nothing wrong with your sheet, you have to pull cell E3 down, that's all, and the other values will be populated
Reply With Quote
  #18  
Old 11-12-2021, 12:05 PM
silverman166 silverman166 is offline Show a list of plants requiring a minimum temperature Windows 10 Show a list of plants requiring a minimum temperature Office 2007
Novice
Show a list of plants requiring a minimum temperature
 
Join Date: Nov 2019
Posts: 27
silverman166 is on a distinguished road
Default

Ah, at last!!

Thankyou.
Reply With Quote
Reply

Thread Tools
Display Modes


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 09:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft