Excel VBA replace duplicates for large formula

[Eisasuarez]

Hi All,

I have some percentages for 3 weeks for 3 different Areas in

Area 1) B1:V100
Area 2) AB1:AV100
Area 3) BB1:BV100

now what i want to do is get the 5 largest values for each day

5 largest for each day
ie B1:B100
C1:C100
D1:D100 etc


Now i know i can rank them and use a countifs formula for each day to get around this by adding 0.00000001 + row() to that value but that would mean i would need to create this for every day

Now to avoid this...i want to create a macro that would change any duplicates for Each day by adding some small values for each day so that way i can use my large formula on the ranges mentioned without having to create rank, countifs for each day

any help will really be appreciated

After some Vba code please

thank you

 

[Eisasuarez]

Please let me know if you need more information or if ive made no sense