=SEQUENCE(عدد الصفوف المطلوب فيها اعداد متتالية)
Adding a Dynamic Numbered List
Let’s improve the readability of the report by adding rank numbers in column F. This is a simple matter of adding a SEQUENCE function in the column beside our SORT/FILTER function.
- Select cell F8 and enter the following formula:
(click on the formula for a larger view)
To account for times where the user may enter a value for the Top N that is greater than the number of items in the dataset, we will include a check using the COUNT function to determine if the user has selected more entries than the list can provide. If they do, it will display a friendly message.
ليست هناك تعليقات:
إرسال تعليق