View Single Post
 
Old 11-10-2021, 06:06 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Is there some real reason you can't simply use a filter?

Add header row to your table, e.g. Plant, MinTemp;
Activate any single cell in table, and select from menu an Filter option (in my version of Excel it is Home.SortAndFilter.Filter) - you get selection options at column headers;
For 'Min temp' column, click on filter option, select 'Number Filters', then 'Greater than', and type 5 into condition field. Click OK, and you get what you wanted! You didn't like the result - change the filter condition in any way you like.
Reply With Quote