SMALL (known as KÜÇÜK in Turkish) function is used to find the nth smallest value from a dataset. It is available in both Microsoft Excel and Google Sheets and is highly functional for data analysis, statistical analyses, and report preparation.

Syntax and Parameters

The general syntax of the KÜÇÜK function is as follows:

=KÜÇÜK(array; n)

• array: The range of cells or list of numbers from which the smallest values are to be retrieved.
• n: A number specifying which nth smallest value should be returned.

Example usage:

=KÜÇÜK(A1:A10; 2)

This formula returns the second smallest number found in the range A1:A10.

Practical Usage Scenarios

Below are various scenarios where the KÜÇÜK function can be applied along with sample solutions.

Scenario 1: Class Ranking

A teacher wants to assess the test scores of students in a class and determine each student”s rank within the class. The KÜÇÜK function can be used for determining these rankings.

=KÜÇÜK(B2:B5; 2)

This formula is used to determine the second highest score, which is 88. By repeating this operation for other rankings, the entire class ranking can be established.

Scenario 2: Product Stock Management

A store manager wants to analyze the stock quantities of products in inventory to identify products with the lowest stock levels. This information is crucial to understanding which product needs reordering.

=KÜÇÜK(B2:B5; 1)

This formula returns the product with the smallest stock quantity in the inventory, which is 50 and belongs to Product D. This is a product that requires urgent reordering.

With the KÜÇÜK function, it is possible to quickly extract specific values from datasets and accelerate decision-making processes based on this information. Being proficient with such functions when working with numerical data enhances efficiency and saves time.

Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/küçük-işlevi-17da8222-7c82-42b2-961b-14c45384df07