4 Replies Latest reply on Jun 8, 2018 6:24 PM by Bryce Larsen

    Need Help Grouping Dates

    Alex Foster

      Hi all,

       

      I need to group consecutive weeks within a market together. So for instance, 5/14-5/28 would all get a 1 then 1/1-1/15 would get a 2 and so on until it reaches the next market at which point the sequence should start back at 1. I created a Rank table calc using INDEX() but not sure where to go from there. Any help would be greatly appreciated!

       

      Note: The clusters usually span 3 weeks but not always