Extract smallest and Largest number for Single Criteria using IF function
In this video, you will learn how to extract the smallest, largest number coupled with IF function to ensure that they meet a single criteria.
1. Large Function is widely used to extract the number with specified instance. Using this function any largest data can be extracted.
2. Similarly, small function is used to extract any number of small data.
If function is used to ensure that the criteria is met and accordingly the large or smallest data will be fetched.
#largest #smallest #exceltipsandtricks #excel.
Keep Watching,Keep Learning.