upper and lower limit index search

[johnmacs5]

I am a little new to this, i am using the below array formula to capture entries and generate the lists for the less than 30 and the more than 365 but need help in how i would configure to search between 31-60, 61-90, 91-180 and 181-365. Any ideas?

=IFERROR(INDEX('YTD Terms'!$K$10:$K$140,SMALL(IF('YTD Terms'!$G$10:$G$140<=30,ROW('YTD Terms'!$K$10:$K$140)-ROW('YTD Terms'!K$10)+1),ROWS('YTD Terms'!K$10:'YTD Terms'!K10))),"")

[JohnTopley]

Try

=IFERROR(INDEX('YTD Terms'!$K$10:$K$140,SMALL(IF(('YTD Terms'!$G$10:$G$140>=31)*('YTD Terms'!$G$10:$G$140<=60),ROW('YTD Terms'!$K$10:$K$140)-ROW('YTD Terms'!K$10)+1),ROWS('YTD Terms'!K$10:'YTD Terms'!K10))),"")

Enter with Ctrl+Shift+Enter

Adjust highlighted values for other ranges

[johnmacs5]

Worked perfectly, thanks a million

[JohnTopley]

My pleasure.

Can you please mark thread as solved ("Thread Tools" at top of first post)