Yes this solved the case. Can you please give me your email id so that i can communicate directly? I have a long database now.
On Oct 21, 6:10 pm, Dave Bonallack <davebonall...@hotmail.com> wrote: > Hi, > Have a look at the attached to see if it does what you need. > Regards - Dave. > > > > > Date: Wed, 20 Oct 2010 20:04:57 -0700 > > Subject: $$Excel-Macros$$ Finding student whose marks are improving over > > three consecutive tests > > From: vaaibhavjhav...@gmail.com > > To: excel-macros@googlegroups.com > > > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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&;... > > > > Students.xls > 29KViewDownload -- ---------------------------------------------------------------------------------- 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
