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
Bookmarks