hello, hope you can help,have a worksheet with 2 sheets,class,table.in m1:r1 subject headings and m2:m8 will be pupils names and test scores for that class subject, same for rest with different names for different subjects.anyhow i will have a2:f2 poulated randomly from the lists in m2:r8 ei(a2 will have a name from between m2:m8,ei p lyons 57) p lyons been student name 57 been test score.what i would like is for to pick 3 top test results from a2:f2 and then convert each of them to a 1 and then from that transfer them to table sheet.if anyone is interested in helping i will gladly send a copy for you to examine.as really is a bit complicated to explain.thanks.
--~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
