Hi everyone,

I have a spreadsheet with groups of scores in column "G"

I need to select 5 scores from each group i.e. the lowest, the highest, the middle, the score between the middle and lowest and the score between the highest and middle

E.g.

33
34
35
35
36
37
37
37
38
38
40
42 Low score = 33
43 Middle Low score = 36.5
45 Middle score = 40
46 High Middle score = 43.5
47 High score = 47

how can i loop through each group, and highlight (color index = 6) the matching scores, or the closest one when there is no exact match??

Each group of scores is separated by 4 blank rows

Can this be done??


Thanks

Will04