Advance Excel SKILLS NEEDED

Job ID: 36020013

Budget: ₹600 – ₹1,500 INR

Hi, I have two excel sheets of daily data of Nifty and Bank nifty.

Requirement- I need a weekly change from High to a low of Bank Nifty and Nifty from Thursday to Thursday.

Requirement- Percentage change from high to low weekly.

Requirement- How many weeks average is below 3%, 3% to 5%, and above 5%?