Trevor Norman
New Member
- Joined
- Aug 6, 2020
- Messages
- 4
- Office Version
- 2016
- Platform
- Windows
I refer to the post Averaging lowest values which I an trying to replicate ie I wish to average the smallest 5 numbers out of the last 10, with the possibility that there may be blanks in between, in which case I need the last 10 numbers.
I have copied the formulea however I get a message that excel is out of resource.
I have also tried to limit the number of cells to check on, say 50, as opposed to the complete column but the I have an #REF error.
I would prefer if the range of ceels to check was a row, as opposed to a column, say B5 to B55
Any help appreciated
Thank you
I have copied the formulea however I get a message that excel is out of resource.
I have also tried to limit the number of cells to check on, say 50, as opposed to the complete column but the I have an #REF error.
I would prefer if the range of ceels to check was a row, as opposed to a column, say B5 to B55
Any help appreciated
Thank you