#### tyija1995

##### Well-known Member

- Joined
- Feb 26, 2019

- Messages
- 766

- Office Version
- 365

- Platform
- Windows

I have a field of integers residing in cells B3:B26 (randomly ranging from 2 to 22)

I have made an array formula to return a list of integers that are greater than or equal to 10 (in numerical ascending order)

However when I try to do the same but with an AND formula to get numbers between 10 and 15 inclusive, I get a #VALUE ! error.

Working formula (cell C3 - array for greater or equal to 10):

=SMALL(IF($B$3:$B$26>=10,$B$3:$B$26,""),ROW()-2)

CSE and dragged down until I start getting #NUM errors - then I just remove.

Broken formula (cell D3 - array for between 10 and 15 inclusive):

=SMALL(IF(AND($B$3:$B$26>=10,$B$3:$B$26<=15),$B$3:$B$26,""),ROW()-2)

CSE - #VALUE ! returned.

Any ideas? I'm not sure why the array formula doesn't like the AND statement.

Thanks