Hi DILIPandey,

Lesson learned for next time - thank you!

I've updated my original post and also attached 'Example2.xlsx' with updated values in Column A. A5 and A9 are still the only two values which meet the criteria (18 & 6), so the average should be 12.

Thank you for your help.

Kind regards,
Matt