hi, Extremely busy for weeks. See afterward. Remind me later.
On 6/4/14, Mukesh Baviskar <[email protected]> wrote: > Hi, > Thank you. Will you please modify the sheet as per your suggestion and send > > it to me on my personal email id as a attachment. Do change the file into > macro enable file. > > Waiting to receive a positive solution. > > Thank you. > > Regards, > > Mukesh Baviskar > Mobile: 9403161157 > > > -------------------------------------------------- > From: "Him Prasad Gautam" <[email protected]> > Sent: Wednesday, June 04, 2014 2:57 PM > To: "AccessIndia: a list for discussing accessibility and issues > concerningthe disabled." <[email protected]> > Subject: Re: [AI] Excel formula required > >> hi, >> There is not a ready made formula. >> However, you can do it easily with yourself. >> 1. In the sheet in which you want put the top five student, just link >> the cell like sheet1!a1 >> 2. Sort the sheet with the marks . >> 3. The name, subject, marks will be automatically adjusted. >> Alternatively, you can use the validation command to a cell too. >> The name can be auto generated as said in hint 1. >> For auto sorting, a macro coding is essential. >> >> >> >> >> >> On 6/4/14, Mukesh Baviskar <[email protected]> wrote: >>> Dear friends, >>> I want to find out the first 5 students in each subject. In the attached >>> file there are 10 tables on sheet 2. I want to fill out these table by >>> formula. The name of student and his role number should also come by >>> formula. If there are more students having same marks in subject then >>> they >>> should also consider in top 5. The number of student then may be 6 or 7. >>> >>> For >>> example in hindi subject there are 3 students having same marks (46) so >>> there will be 6 students in the table. The main result sheet is on sheet >>> >>> 1. >>> >>> Please see the file on the following link. >>> >>> https://dl.dropboxusercontent.com/u/21186849/first%20five.xlsx >>> >>> Thanking you in anticipation. >>> >>> Regards, >>> Mukesh Baviskar >>> Mobile: 9403161157 >>> >>> >>> Register at the dedicated AccessIndia list for discussing accessibility >>> of >>> mobile phones / Tabs on: >>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>> >>> >>> Search for old postings at: >>> http://www.mail-archive.com/[email protected]/ >>> >>> To unsubscribe send a message to >>> [email protected] >>> with the subject unsubscribe. >>> >>> To change your subscription to digest mode or make any other changes, >>> please >>> visit the list home page at >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> >>> >>> Disclaimer: >>> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >>> >>> the >>> person sending the mail and AI in no way relates itself to its veracity; >>> >>> 2. AI cannot be held liable for any commission/omission based on the >>> mails >>> sent through this mailing list.. >>> >> >> >> -- >> Him Prasad Gautam >> Kathmandu, Nepal >> >> >> >> Register at the dedicated AccessIndia list for discussing accessibility of >> >> mobile phones / Tabs on: >> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >> >> >> Search for old postings at: >> http://www.mail-archive.com/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> >> >> Disclaimer: >> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >> the person sending the mail and AI in no way relates itself to its >> veracity; >> >> 2. AI cannot be held liable for any commission/omission based on the mails >> >> sent through this mailing list.. > > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > > To unsubscribe send a message to > [email protected] > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > -- Him Prasad Gautam Kathmandu, Nepal Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
