Automatically Rank Data in Microsoft Excel Using VBA | Excel Tip #shorts

In this video i will show you a ttrick on how to Automatically Rank data in Excel in less than 1 minute.

0:00 Intro - How to Rank Data in Excel
0:48 Outro

'*************Code************
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

'Select the last row
LastRow = ActiveSheet.UsedRange.Rows.Count

'Sort the data
Range("A1:B" & LastRow).Sort _
Key1:=Range("B1"), _
Order1:=xlDescending, _
Header:=xlYes

End Sub
'*************Code************

#learnexcel #exceltrick

About Me 😁
This channel is all about helping you improve your Excel and data skills including Office Productivity (Microsoft Excel, Word, PowerPoint, VBA, Google Sheets). My aim is to help you power up your knowledge in no time and take your skills to the next level.

My videos will help you improve your skills and improve your chances in careers in Data Science, Banking and Accounting & Finance.

Please subscribe =)

[ExcelAtData]

Thanks for watching. Please like 👍 the video 📺 & subscribe, don't forget to hit the bell icon 🔔 so you never miss a tutorial.

What do you struggle with in Excel? Tell me in the comments session below! 👇