Excel Student Rank Automation

I have a list of student marks sitting in an Excel sheet and I need it organised so I can see, at a glance, who is performing best overall. The task is simple but accuracy is critical: sort every record by total marks and assign a clear rank for each student. In the final list I only need the student names displayed alongside their rank and total; any extra columns can stay hidden or be removed entirely.

Feel free to work with formulas, filters, PivotTables, or a quick VBA macro—whatever lets you deliver a clean, well-ordered sheet I can drop straight back into my reports.