can you attach the sample file On Thu, Feb 3, 2011 at 4:54 PM, lifeactuary <lifeactu...@bellsouth.net>wrote:
> Class 1 2 > 3 4 5 6 7 > 8 9 10 11 > Priority 1 > 7 4 11 6 3 > 3 1 2 > RevisedPriority 1 8 > 6 9 7 4 5 > 2 3 > > > The row "Priority" represents the values actually chosen.(1 is the > highest priority, 11 is the lowest)) > No selection was made for Class 1 or Class10 > Priority1 was duplicated for Class 2 and Class 9 > Priority3 was duplicated for Class 7 and Class 8 > Priority 5,8,9, & 10 were left out > RevisedPriority is the result of reordering the priorities by > eliminating duplicates and closing gaps. > > In eliminating dupes, the first occurrence takes precedence and the > next occurrence is incremented by 1 > So, in the case of Priority 1 for Class 2 and Priority 1 for Class 9, > Priority 1 for Class 2 remains a 1, > and the Priority for Class 9 becomes a 2, which then involves a > duplicate with Priority 2 for Class 11 and the process continues > > I'm looking for a macro that will do this for a variable number of > classes > Thanks in advance. > > -- > > ---------------------------------------------------------------------------------- > 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/discussexcel > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- 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/discussexcel
