Ranking data based on set criteria

Hi,

I am trying to create a macro that ranks my data based on criteria in 3 different fields.

For each state (column A) for each month (column C) if Column L = "Y" then rank based on values in column J in column Q.

eg. for NSW, I want to see the revenue ranked highest to lowest for each month with the rank placed in column Q.

I have attached some sample data, and the code is below.

I have not been able to get the macro to work (I'm sure those with knowledge could pin point the problem straight away) and that is only based on trying to get the all of the data ranked based on state, without the other criteria needed.

Any help would be much appreciated.

Book1.xlsx

Please Login or Register  to view this content.

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.