Hello I have got sample data as follows:
Marks in a single subject Student Class Marks Test A X 20 First B XI 25 First C V 12 First A X 25 Second B XI 23 Second C V 12 Second D VII 34 Second A X 75 Third B XI 34 Third C V 87 Third D VII 12 Third Now I want some ability that I am able to find the list of all students who have got higher marks continuously i.e. Third Test Marks>Second Test>First Test. Further I want a functionality that when I add marks of Fourth Test in the sheet above then I shall need names of students whose marks are increasing from last 3 tests i.e. Fourth Test>Third Test>Second Test. In this case First test marks are irrelevant and so on for fifth, sixth, seventh tests........... -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
