Happy V day ! I wonder if anyone have written a marco that can rank the data into top 10%, 20% and 30%. As you can see I am doing it using Rank function in column D and then using If function in column F to get the final output. I want to write a VBA to do so but I don’t how… Many Thanks Percentage Rule.xlsx