onthegreen03
Board Regular
- Joined
- Jun 30, 2016
- Messages
- 148
- Office Version
- 365
- Platform
- Windows
Hi - I have numbers in cells A8:A65 and I am looking for a formula that will return the lowest 5 numbers in that range. I tried this formula but it did not work: =SMALL($A$8:$A$65, ROWS(BE$45:BE45)). Cell BE45 is where I want the first result to land, then I will drag that formula down 4 more rows. What am I doing wrong? I should mention that some of the cells in A8:A65 can be blank so I'd want the formula to ignore the blanks. Any help would be appreciated. Thanks in advance!