Tsvaga Avhareji (Mamiriro) Ne Excel yeMODE Function

Iyo nzira yeurongwa rwehutano hwemashoko inorondedzerwa sechinhu chinowanzoitika kakawanda pane urongwa.

Somuenzaniso, mumutsara wechipiri mumufananidzo uri pamusoro, nhamba yechitatu ndiyo nzira sezvo inowanikwa kaviri mumatsetse eA2 kusvika D2, asi dzimwe nhamba dzose dzinoonekwa kamwe chete.

Nzira yacho inofungidzirwawo, pamwe chete neanoreve uye neyemukati, kuva chiyero chepakati pekukosha kana chimiro chepakati chedata.

Nokuda kwekupararira kwemashoko akazara - inomiririrwa mifananidzo nechenda yebhere - muyero wezviyero zvitatu zvehutano hwepakati inokosha zvakafanana. Nokuda kwekugoverwa kwekutsvaga kwemashoko, muzana wehutano hunogona kusiyanisa pane zviyero zvitatu.

Kushandisa basa reMODE muExcel kunoita kuti zvive nyore kuwana kukosha kunowanzoitika kakawanda pane zvakasarudzwa zve data.

01 of 03

Tsvaga Chinhu Chinoitika Zvikuru Kwazvo MuRange Data

Kuchinja kune Basa reMODE - Excel 2010

MuExcel 2010 , Microsoft yakaratidza nzira mbiri dzekushandisa zvinangwa zvose MODE basa:

• MODE.SNGL Basa: rinoshandiswa kudhipatimendi rine imwe chete mode - yakafanana nemabasa eMODE akafukidzwa pano;
• MODE.MULT Basa: rakashandiswa kana data inogona kunge ine maitiro akawanda - maitiro maviri kana akawanda anowanika nehuwandu hwakafanana.

Kuti ushandise MODE inoshanda nguva dzose muExcel 2010 uye inotevera shanduro, inofanirwa kuiswa manyore, sezvo pasina bhokisi rebhokisi rinobatanidzwa naro mumashanduro aya epurogiramu.

02 of 03

Iko Syntax yeMagetsi uye Arguments

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo.

Izwi rechirevo cheMODE ndechekuti:

= MODE (Nhamba1, Nhamba2, Nhamba3, ... Nhamba255)

Nhamba1 - (inoda) maitiro anoshandiswa kuverenga mamiriro acho. Iyi nharo inogona kuva:

• iyo nhamba chaiyo - yakaparadzaniswa nema-commas - muenzaniso mumutsara 3 mumufananidzo uri pamusoro;
• bhora rimwechete rine zvinyorwa zvinoreva nzvimbo ye data pane pepaji - mienzaniso mumiromo 2, 5,6, uye 7;
• kusanganiswa kwemaferensi ekunyorwa uye deta - muenzaniso mumutsara wechina;
• a zita rakasiyana;
• mumwe sero sezviratidzo zvakaparadzaniswa nemakasita.

Nhamba2, Nhamba3, ... Nhamba255 - (zvichida) mamwe maitiro kana kuti masero zvinyorwa kusvika kusvika pa 255 zvinoshandiswa kuverenga mamiriro acho.

Notes

1. Kana iyo yakasarudzwa data yakatarisa isina deta yedhipatimendi, basa reMODE richadzoka # N / A kukosha kwekukanganisa - sezvakaratidzwa mumutsara we7 mumufananidzo uri pamusoro.
2. Kana mitemo yakawanda mumasarudzo akasarudzwa ichiitika nehuwandu hwakafanana (mune mamwe mashoko, data inowanzova nemamiriji akawanda) basa rinodzoka kutanga rokutanga iyo iyo inosangana seyo nzira yezvinhu zvose zvakagadzirirwa - sezvinoratidzwa mumutsara we 5 mumufananidzo pamusoro apa . Dhizinesi re data A5 kusvika D5 rine 2 modes - 1 uye 3, asi 1 - nzira yekutanga yakasangana - inodzorerwa seyo nzira yezera rose.
3. Basa racho rinorega:
   • text strings;
   • zvinonzwisisika kana maBoolean maonero;
   • masero asina chinhu.

MODE Function Example

03 of 03

MODE Function Example

Mumufananidzo wepamusoro, basa reMODE rinoshandiswa kuverenga nzira yezvikamu zvakasiyana zve data. Sezvakataurwa, kubvira Excel 2007 hapana bhokisi rebhokisi rinowanikwa pakupinda mubasa uye nharo dzaro.

Kunyange zvazvo basa racho rinofanira kunge rakapinda nemunhu, zvisarudzo zviviri zvichiripo zvekupinda mumagariro ebasa:

1. kunyora munharaunda kana zvinyorwa zvinyorwa;
2. uchishandisa pfungwa uye chengeta kuti usarudze sero zvinyorwa mumushandi webasa.

Kubatsira kwendima uye kuvhara - kunosanganisira kushandiswa kwemushonga kusimbisa masero e data - ndeyokuti inoderedza mikana yezvikanganiso zvakakonzerwa nokunyora zvikanganiso.

Pasi panonyorwa matanho anoshandiswa kuisa maMODE basa muchikamu cheF2 mumufananidzo uri pamusoro.

1. Dzvanya pachitokisi F2 - kuti uite sero rinoshanda;
2. Tora zvinotevera: = mode (
3. Dzvanya uye dhonza ne mouse kuti uone masero A2 kusvika kuD2 mubasa rekushanda kuti uise huwandu uhwu semafungiro emabasa;
4. Tora chivharo chekuvhara mavhareji kana vabereki " ) " kuvhara basa rekuita;
5. Dhinda pikicha inopinda mubhokisi kuti upedze basa;
6. Mhinduro 3 inofanira kuonekwa muchitokisi F2 sezvo nhamba iyi inowoneka yakanyanya (kaviri) mumutsetse we data;
7. Paunenge uchinge uri pafoni F2 yakakwana basa = MODE (A2: D2) inowanikwa mubhairi yepamusoro pane pepa pepaji.