Скачать или смотреть #excel

Hello 👋. Good to see you here!

In this video, we will discuss an amazing function called Rank, which will be used to assign a rank based on a criteria.

In this trembling fast growing world towards Al, analysts always don't get the data in a clean format and cleaning the messy data is pain in head😅.

If you are assigning ranks manually, you need to scan and entire column for each rank. If there are 5 rows of data, it will be ok. What if there are 100s and 100s of rows of data? Doing manually will be easy?

That’s when rank function comes to rescue. It will assign ranks automatically based on a criteria.

Here, we have Names and their Marks. We will rank based on their Marks. So our criteria becomes Marks.

You can see that while selecting range we have used @ symbol. This helps us to make the data dynamic instead if dragging the formula for every newly added row.

Hope you learnt something 🆕.

See you in the next video ✌️ ✌️

#excel #excelformula #exceltips #exceltricks #exceltutorial #exceltricks #exceltraining #excelshortcuts #excelshortcuts #rank #rankings #ranking #ranked #vlookup #xlookup #hlookup #dataanalysis #dataanalytics #datanalytics #datadeer #shortsfeed #shorts #viral #viralvideo #viralshorts #trending #trendingshorts

@D‪@Datawithdeer‬