I have several rows of data, and would like the 5 smallest of the last 10 entries that contain data, i.e. ignoring the blank cells. For example if in Column A I had:
50
30
80
40
10
90
100
20
60
70
New entries are added to the bottom of the list, sometimes blank and other times not. Is there a way to use Offset with Small or some other functions to return the 5 lowest values in the last 10 entries ignoring the blank cells? (The data will also be numerical as well)
50
30
80
40
10
90
100
20
60
70
New entries are added to the bottom of the list, sometimes blank and other times not. Is there a way to use Offset with Small or some other functions to return the 5 lowest values in the last 10 entries ignoring the blank cells? (The data will also be numerical as well)