Select the highest/lowest n values from a sorted column

I'm sorry if I'm not helping here.
Just want to understand what did you mean by this :

Originally Posted by ShannayR

I am attempting to create a new sub to run after the sorting sub that would
select the highest and lowest n (e.g. 3) values

Because from the image you post,
I thought the highest score is 24 and the lowest score is 5 ?

Originally Posted by karmapala

I thought the highest score is 24 and the lowest score is 5 ?

I want to select the 3 highest scores (24, 18, 14) from the dataset.
I cannot fix the 3 values as I am looking for a more inclusive way of carrying out the operation that can be used in a variety of uses.
Defining

lNumTopEntries

was to incorporate this flexibility.

Originally Posted by mikerickson

Since it has already been sorted the top and the bottom values are at the edge of the range.

That worked out fairly well, but how do I select recurring values? In the posted data, selecting the top 3 values should get the sub to select sample3:sample9.
The code only selects the first 3 rows without checking if the values are repeating.