Describe a method to dynamically rank data within Excel without manually updating the ranking.

Instruction: Explain how you can use Excel functions to create a dynamic ranking system that updates as the data changes.

Context: This question checks the candidate's ability to manipulate data dynamically, allowing for real-time data analysis and decision-making.