View Single Post
 
Old 11-12-2021, 06:49 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

1. The IFERROR was added to avoid errors when while pulling down, there are no more results satisfying your requirements
2 Your original file has a value of "<5" in D3. This is a text string and will not work as such when comparing to numbers from col B. So you have to replace it with a single value, not using a text string

3 The Pivot Table was another example I provided for a possible solution. Although it is not necessary for a small table, it would be helpful for larger tables.

4. The solution provided is an array formula. They tend to slow down sheets with large ranges and most are nowadays replaced with built-in functions in newer XL versions like O365
Attached Files
File Type: xlsx Copy of Plants_1.xlsx (10.2 KB, 9 views)
Reply With Quote