Hi Everyone,
Thank you for taking the time to read this, I have given a small example of what I intend to achieve in an attached file.
I want to be able to display the names of the pupils who meet my criteria.
Example in Test 1, there were 3 pupils who achieved an "A" from class 2.
I need to see in a message box Sally, Romeo and Wendy.
I would be greatful for any help or starting point as I think this is done in visual basic for which i have no expereince in? Also if possible an explanation of what is happening in the code would be beneficial as i can gain an insight and appreciate this aspect of excel.
Thank you.
Bookmarks