|
|
|
|
#1
11-09-2021, 08:41 AM
|
||||
|
||||
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))) 
|
|
#2
11-09-2021, 02:04 PM
|
|||
|
|||
|
OK Thanks Pecoflyer, and I'm using xl 2013.
BUT when I copied and tried to paste in your formula, it returned an error as shown in attached, when I did Ctrl,Shift,del
|
|
|
|
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 |
Windows 7 64bit 
Office 2010
Hybrid Mode