Shaqada Habka^(Mode) ee Excel waxay soo celisaa qiimaha ugu badan ee soo noqnoqda ee isku dubaridka ama xogta kala duwan. Habka shaqada ee   Mode waa Mode( number1, [number2,..]).

Gudaha Excel , Qaababku^(Modes) waxay noqon karaan habab, lambaro, magacyo, ama talooyin ay ku jiraan tirooyin. Hawshu waxa ay iska indha tirtaa^(Mode) qiyamka sida qoraalka, qiyamka macquulka ah, ama unug madhan oo ku jira array ama dood tixraac. Khaladaadka-qiimaha iyo qoraalka aan loo turjumi karin tirooyinku waxay keenaan khaladaad, haddii xogta ku jirta aysan ku jirin xog nuqul ah, Habka^(Mode) wuxuu ku soo laaban doonaa qiimaha qaladka #N/A.

Gudaha Microsoft Excel , shaqada Habka^(Mode) waxa loo kala saaray inay tahay shaqo ku waafaqid waxayna ku talinaysaa in la isticmaalo MODE.MULT iyo MODE.SNGL beddelkeeda.

Syntax-ka ee shaqada Habka

• Number1 : Doodda lambarka oo aad rabto inaad ku xisaabiso Habka^(Mode) . Waa loo baahan yahay.
• Number2 : Doodda lambarka labaad^(Second) ee aad rabto inaad ku xisaabiso Habka^(Mode) . Waa ikhtiyaari.

Sida loo isticmaalo shaqada Mode ee Excel

Fur Microsoft Excel .

Samee miiska ^(Create)Excel oo leh dhowr tiro oo soo noqnoqda.

Ku qor unugga aad rabto inaad natiijada dhigto, =MODE(A2:E2) .

A2: E2 waa meesha xogta kala duwan ay tahay.

Kadib riix furaha Enter , waxaad arki doontaa natiijada.

Waxaa jira hab kale oo loo isticmaalo shaqada Mode .

Guji badhanka fx ee sare ee xaashida shaqada ee Excel.

Sanduuqa wada hadalka Gelida^{(Insert Function)} ayaa furmi doona.

Gudaha sanduuqa wada-hadalka Insert Function , ee sanduuqa ^{(Insert Function)}Function Search^{(Search Function)} , ku qor Habka^(Mode) sanduuqa.

Kadib, dhagsii Go .

Qeybta Xulashada Shaqada^{(Select a Function)} , dhagsii Habka^(Mode) sanduuqa liiska.

Markaa. Guji OK _

Sanduuqa wada hadalka doodaha Functions^{(Functions Arguments)} ayaa soo bixi doona.

Gudaha sanduuqa wada hadalka doodaha Functions^{(Functions Arguments)} , meesha aad ku aragto Number1 , waxaan ku qor sanduuqa gelitaanka A2: E2 sababtoo ah tani waa kala duwan ee unugyo halkaas oo aan rabno in ay helaan Habka^(Mode) .

Number2  waa ikhtiyaari.

Guji OK , oo waxaad arki doontaa natiijada.

Waxaan rajeynayaa in tani ay caawineyso; haddii aad wax su'aalo ah qabtid, fadlan faallo ka bixi hoos.

Akhri soo socda^{(Read next)} : Sida loo isticmaalo Beddelka iyo Bedelka Hawlaha gudaha Excel^{(How to use Substitute and Replace Functions in Excel)} .

How to use the Mode function in Excel

The Mode function in Excel returns the most frequently repetitive value in an array or range of data. The formula for  Mode function is Mode( number1, [number2,..]).

In Excel, Modes can be arrays, numbers, names, or suggestions that contain numbers. The Mode function ignores values such as text, logical values, or empty cells in an array or reference argument. Error-values and text that cannot be translated into numbers cause errors, and if the data set contains no duplicate data, the Mode will return to the #N/A error value.

In Microsoft Excel, the Mode function is classified as a compatibility function and recommends using the MODE.MULT and MODE.SNGL instead.

The Syntax for the Mode function

• Number1: The number argument for which you want to calculate the Mode. It is required.
• Number2: The Second number argument for which you want to calculate the Mode. It is optional.

How to use the Mode function in Excel

Open Microsoft Excel.

Create an Excel table with a few repetitive numbers.

Type into the cell where you want to place the result, =MODE(A2:E2).

A2:E2 is where the range of data is.

Then press the Enter key, you will see the result.

There is another method to use the Mode function.

Click the fx button at the top of the excel worksheet.

An Insert Function dialog box will open.

Inside the Insert Function dialog box, at the Search Function box, type Mode into the box.

Then, click Go.

At the Select a Function section, click Mode in the list box.

Then. Click OK.

A Functions Arguments dialog box will appear.

Inside the Functions Arguments dialog box, where you see Number1, we type into the entry box A2:E2 because this is the range of cells where we want to find the Mode.

Number2  is optional.

Click OK, and you will see the result.

I hope this helps; if you have questions, please comment below.

Read next: How to use Substitute and Replace Functions in Excel.

Related posts

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Sida loo suurtageliyo Mode-madow ee Word, Excel iyo PowerPoint

• Sida loo Furo Word iyo Excel si Badbaado ah

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Khaladka Run-time 1004, Ma socodsiin karo Macro gudaha Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sida loogu daro Koodhka Dalka ama Goobta Liiska Lambarka Taleefanka ee Excel

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel