How to Find Out Minimum Value within Criteria

Assalamu'alaikum Warohmatullahi Wabarokatuh,

On this video I would like to explain about how to find minimum value within certain criteria. For example, if we have data and we will search minimum value above 60 for passing grade criteria, we can use the combination of minimum, if, and Array function. Here is the formula:
{=min(if(array data more than = 60,array data))}
We activate array formula {} by pressing Ctrl + Shift + Enter at once when the formula is done.

We also can find out Rank Function within criteria above and equals to 60 by this formula:
{=small(if(array data more than = 60,array data),k)}

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

Here there are top 5 videos ‪@ambarilhamchannel‬ when this video is being uploaded:
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...  

Enjoy this video, I hope it's worthied for every learner. If you have any question about Ms. Office Excel, Word, or Google Sheet, 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