Ranking data based on set criteria

Hey Panfergrrl18,

No VBA code may be needed for this problem. See the attached with a filter in col L, and rows of state and date and amts and ranks. Hope this helps. Pivot Tables are great if you learn how to use them. You can rank low to high or high to low.