Consulting

Results 1 to 12 of 12

Thread: VBA code to find highest and 2nd highest number based in criteria

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 10-24-2011, 05:15 PM #1
    Michaelk
    Michaelk is offline
    VBAX Regular
    Joined
    Oct 2011
    Posts
    6
    Location

    VBA code to find highest and 2nd highest number based in criteria

    I need the VBA code to find the highest and 2nd highest value in a column based on criteria in another column. So for example:
    Type | Time
    RaceA| 4.5
    RaceB| 5.5
    RaceA| 6.2
    RaceA| 3.1
    RaceB| 2.1
    I need the VBA code to be able to find the highest and 2nd highest Time for RaceA and highlight them in different color. So in the example above, the code should loop through the time based on Type and highlight 3.1 as highest and 4.5 as second highest
    Can anyone help pls?
    Last edited by Michaelk; 10-24-2011 at 05:32 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules