Large and Small Function with No Criteria - One Criteria - Multiple Criteria | Eng Version

Assalamu'alaikum Warohmatullahi Wabarokatuh

On this video I explain about rank function with no criteria, one criteria, and Multiple Criteria.
Basic formulal for rank is:
=Large(Array,k) for largest to smaller rank
=Small(Array,k) for smallest to larger rank

One Criteria:
{=Large(if(cell ref=Array Ref,Array),k)}
{=Small(if(cell ref=Array Ref,Array),k)}

Multiple Criteria:
{=Large(if(cell ref1&cell ref2=Array ref1&Array ref2,Array),k)}
{=Small(if(cell ref1&cell ref2=Array ref1&Array ref2,Array),k)}

Here is Excel Template: https://docs.google.com/spreadsheets/...

Herewith my top 5 videos ‪@ambarilhamchannel‬ when I upload this video:
1. 30 Excel Formulas for PPIC:
   • 30 RUMUS EXCEL WAJIB BAGI PPIC  
2. How to Lock Cells in Excel:
   • Locked Cells Excel, Rumus, by Format Cells...  
3. Typing Fast Tutorial with 10 Fingers:
   • Tutorial Belajar Mengetik 10 Jari | Belaja...  
4. How to Calculate Age in Excel:
   • Cara Menghitung Umur pada Excel  
5. How to Create Gantt Chart Schedulle Automatically:
   • Cara Membuat Tabel Kegiatan Otomatis | Gan...  

If you have any questions regarding to Microsoft Excel, Word, or Google Sheets, please write down on the comment below. God Willing I will answer it on the next video.

Wassalamu'alaikum Warohmatullahi Wabarokatuh

#excel
#msexcel
#excel_tutorial
#tutorialexcel