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
