Home معادلات إكسيل

كيفية استعمال الدالة RANG في الإكسل

September 17, 2021

كيفية استعمال الدالة RANG في الإكسل

في هذه المقالة سيتم التطرق لشرح كيفية استعمال الدالة RANG والتي تعتبر من الدوال المهمة في الإكسيل.

تقوم الدالة RANG في Excel بتحديد رتبة القيمة بناءً على مجموعة من القيم.

يستخدم :

=RANG(valeur; ensemble_de_valeurs; ordre)

مثال على الاستخدام

الهدف هنا هو تحديد ترتيب لللاعبين وفقًا لعدد نقاطهم:

كيفية استعمال الدالة RANG في الإكسل

حدد وظيفة RANG:

في "الرقم" ، أدخل الرقم المراد تحديد رتبته.
في "المرجع" ، أدخل نطاق الخلايا الذي يحتوي على جميع القيم.
في "الترتيب" ، اتركه فارغًا (أو أدخل 0) للترتيب التنازلي ، أدخل قيمة بخلاف 0 للترتيب التصاعدي.

كيفية استعمال الدالة RANG في الإكسل

انقر فوق موافق.

كيفية استعمال الدالة RANG في الإكسل

قبل القيام بإعادة النسخ ، أضف $ إلى نطاق الخلايا لمنعه من التغير =RANG(B2;B$2:B$9)ثم قم بتمديد الصيغة لأسفل:

كيفية استعمال الدالة RANG في الإكسل

Tags معادلات إكسيل

Latest articles from : معادلات إكسيل

Comments

No comments

Post a Comment

Reading Mode :

Font Size

+

16

-

lines height

+

2

-

window['__wavt'] = 'AOuZoY6BSa1jvDWVcYezMyqNpn7RurdOOg:1734788962130';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d7172743834752994373','//www.practiceexcel-365.com/2021/07/fonction-excel-rang.html','7172743834752994373'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '7172743834752994373', 'title': 'Practice Excel365 | Free Excel Courses', 'url': 'https://www.practiceexcel-365.com/2021/07/fonction-excel-rang.html', 'canonicalUrl': 'https://www.practiceexcel-365.com/2021/07/fonction-excel-rang.html', 'homepageUrl': 'https://www.practiceexcel-365.com/', 'searchUrl': 'https://www.practiceexcel-365.com/search', 'canonicalHomepageUrl': 'https://www.practiceexcel-365.com/', 'blogspotFaviconUrl': 'https://www.practiceexcel-365.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - RSS\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/7172743834752994373/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/2737406517665695989/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-6657372632750930', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/361ce9cf7a112c52', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '2737406517665695989', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0wKouC65aUzW0Ny-EOoguvk0ARbm21uFeUyVGyjV9wq7RtXVG9ESiCAMQc5n8psclQazYnSaZrOStxZ7xiDmqZATOyK1WnOO8VH0qI5QNEGN3bH0cB7a0GWjIgwaL4NXGf8QiJYz21oY/s72-w640-c-h576/rang+1.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0wKouC65aUzW0Ny-EOoguvk0ARbm21uFeUyVGyjV9wq7RtXVG9ESiCAMQc5n8psclQazYnSaZrOStxZ7xiDmqZATOyK1WnOO8VH0qI5QNEGN3bH0cB7a0GWjIgwaL4NXGf8QiJYz21oY/w640-h576/rang+1.png', 'pageName': '\u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 RANG \u0641\u064a \u0627\u0644\u0625\u0643\u0633\u0644', 'pageTitle': 'Practice Excel365 | Free Excel Courses: \u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 RANG \u0641\u064a \u0627\u0644\u0625\u0643\u0633\u0644', 'metaDescription': '\u062a\u0642\u0648\u0645 \u0627\u0644\u062f\u0627\u0644\u0629 RANG \u0641\u064a Excel \u0628\u062a\u062d\u062f\u064a\u062f \u0631\u062a\u0628\u0629 \u0627\u0644\u0642\u064a\u0645\u0629 \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0645\u062c\u0645\u0648\u0639\u0629 \u0645\u0646 \u0627\u0644\u0642\u064a\u0645.\n\n'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': '\u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 RANG \u0641\u064a \u0627\u0644\u0625\u0643\u0633\u0644', 'description': '\u062a\u0642\u0648\u0645 \u0627\u0644\u062f\u0627\u0644\u0629 RANG \u0641\u064a Excel \u0628\u062a\u062d\u062f\u064a\u062f \u0631\u062a\u0628\u0629 \u0627\u0644\u0642\u064a\u0645\u0629 \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0645\u062c\u0645\u0648\u0639\u0629 \u0645\u0646 \u0627\u0644\u0642\u064a\u0645.\n\n', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0wKouC65aUzW0Ny-EOoguvk0ARbm21uFeUyVGyjV9wq7RtXVG9ESiCAMQc5n8psclQazYnSaZrOStxZ7xiDmqZATOyK1WnOO8VH0qI5QNEGN3bH0cB7a0GWjIgwaL4NXGf8QiJYz21oY/w640-h576/rang+1.png', 'url': 'https://www.practiceexcel-365.com/2021/07/fonction-excel-rang.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 2737406517665695989}}, {'name': 'widgets', 'data': [{'title': 'BlogArchive', 'type': 'BlogArchive', 'sectionId': 'sitting', 'id': 'BlogArchive400'}, {'title': 'BlogLabels', 'type': 'Label', 'sectionId': 'sitting', 'id': 'Label400'}, {'title': 'Pages', 'type': 'PageList', 'sectionId': 'pages', 'id': 'PageList1'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'topsocialL', 'id': 'LinkList3'}, {'title': 'Practice Excel365 | Free Excel Courses (Header)', 'type': 'Header', 'sectionId': 'logo', 'id': 'Header1'}, {'title': '\u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629', 'type': 'LinkList', 'sectionId': 'menu', 'id': 'LinkList22'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0627\u0633\u0641\u0644 \u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0639\u0644\u0648\u064a\u0629 \u0644\u0644\u062d\u0627\u0633\u0648\u0628', 'type': 'HTML', 'sectionId': 'Topa3lan-sc', 'id': 'HTML100'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0627\u0633\u0641\u0644 \u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0639\u0644\u0648\u064a\u0629 \u0644\u0644\u0647\u0627\u062a\u0641', 'type': 'HTML', 'sectionId': 'Topa3lan-sc2', 'id': 'HTML101'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '2737406517665695989', 'title': '\u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 RANG \u0641\u064a \u0627\u0644\u0625\u0643\u0633\u0644', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0wKouC65aUzW0Ny-EOoguvk0ARbm21uFeUyVGyjV9wq7RtXVG9ESiCAMQc5n8psclQazYnSaZrOStxZ7xiDmqZATOyK1WnOO8VH0qI5QNEGN3bH0cB7a0GWjIgwaL4NXGf8QiJYz21oY/w640-h576/rang+1.png', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}, {'name': 'labels', 'label': ''}]}, {'title': '\u0623\u0639\u0644\u0627\u0646 \u0627\u0648\u0644 \u0627\u0644\u0645\u0648\u0636\u0648\u0639', 'type': 'HTML', 'sectionId': 'PostA3lan', 'id': 'HTML201'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0628\u0639\u062f \u0643\u0644 \u0639\u0646\u0648\u0627\u0646 [\u0645\u062a\u0643\u0631\u0631]', 'type': 'HTML', 'sectionId': 'PostA3lan2', 'id': 'HTML222'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0628\u0639\u062f \u0643\u0644 \u0641\u0642\u0631\u0629 [\u0645\u062a\u0643\u0631\u0631]', 'type': 'HTML', 'sectionId': 'PostA3lan2', 'id': 'HTML223'}, {'title': 'Contact Form', 'type': 'ContactForm', 'sectionId': 'AddOns', 'id': 'ContactForm200'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'sidepar', 'id': 'LinkList4'}, {'title': 'Fiver', 'type': 'HTML', 'sectionId': 'Postnw6', 'id': 'HTML3'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'footer-social', 'id': 'LinkList2'}]}]); _WidgetManager._RegisterWidget('_BlogArchiveView', new _WidgetInfo('BlogArchive400', 'sitting', document.getElementById('BlogArchive400'), {'languageDirection': 'ltr', 'loadingMessage': 'Loading\x26hellip;'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label400', 'sitting', document.getElementById('Label400'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'pages', document.getElementById('PageList1'), {'title': 'Pages', 'links': [{'isCurrentPage': false, 'href': 'http://www.practiceexcel-365.com/', 'title': 'Home'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/privacy-policy.html', 'id': '9039293699451073275', 'title': 'Privacy Policy'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/who-are-we.html', 'id': '3848084781500635721', 'title': 'Who We Are'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/contact-us.html', 'id': '5696516493396065643', 'title': 'Contact Us'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/blog-page.html', 'id': '4724947008150640905', 'title': 'Frequently Asked Questions'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList3', 'topsocialL', document.getElementById('LinkList3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'logo', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList22', 'menu', document.getElementById('LinkList22'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML100', 'Topa3lan-sc', document.getElementById('HTML100'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML101', 'Topa3lan-sc2', document.getElementById('HTML101'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/3846405171-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML201', 'PostA3lan', document.getElementById('HTML201'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML222', 'PostA3lan2', document.getElementById('HTML222'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML223', 'PostA3lan2', document.getElementById('HTML223'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm200', 'AddOns', document.getElementById('ContactForm200'), {'contactFormMessageSendingMsg': 'Sending...', 'contactFormMessageSentMsg': 'Your message has been sent.', 'contactFormMessageNotSentMsg': 'Message could not be sent. Please try again later.', 'contactFormInvalidEmailMsg': 'A valid email address is required.', 'contactFormEmptyMessageMsg': 'Message field cannot be empty.', 'title': 'Contact Form', 'blogId': '7172743834752994373', 'contactFormNameMsg': 'Name', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Message', 'contactFormSendMsg': 'Send', 'contactFormToken': 'AOuZoY5J6VLUCk7q7DYhfIIoJ_CslZN4Jw:1734788962131', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList4', 'sidepar', document.getElementById('LinkList4'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'Postnw6', document.getElementById('HTML3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList2', 'footer-social', document.getElementById('LinkList2'), {}, 'displayModeFull'));