Lokacin aiki a cikin Excel, wani lokacin kuna buƙatar ƙididdige yawan layuka a wani takamaiman kewayon. Akwai hanyoyi da yawa don yin wannan. Zamuyi nazarin algorithm don aiwatar da wannan hanya ta amfani da zaɓuɓɓuka da yawa.
Eterayyade yawan layuka
Akwai madaidaitan adadin hanyoyin da za'a iya tantance adadin layuka. Lokacin amfani da su, ana amfani da kayan aikin daban-daban. Sabili da haka, kuna buƙatar duba takamaiman batun don zaɓin zaɓi mafi dacewa.
Hanyar 1: mai nuna alama a cikin mashigin matsayin
Hanya mafi sauƙi don warware aiki a cikin zaɓaɓɓen zaɓi shine duba lamba a cikin masalin matsayi. Don yin wannan, zaɓi zaɓi kawai. Yana da mahimmanci a la'akari da cewa tsarin yana ƙididdige kowane tantanin halitta tare da bayanai don raka'a ɗaya. Sabili da haka, don hana kirgawa sau biyu, tunda muna buƙatar sanin adadin layuka, muna zaɓa shafi ɗaya kawai a cikin yankin binciken. A cikin matsayin matsayin bayan kalma "Yawan" zuwa hagu na maɓallin sauya yanayin maballin, nuni na ainihin adadin abubuwan da aka cika a zangon da aka zaɓa ya bayyana.
Gaskiya ne, wannan kuma yana faruwa lokacin da babu cikakkun ginshiƙai a cikin tebur, kuma kowane layi yana da dabi'u. A wannan yanayin, idan muka zaɓi shafi ɗaya kawai, to waɗannan abubuwan waɗanda ba su da ƙimai a wannan shafin ba za a haɗa su cikin lissafin ba. Sabili da haka, yanzunnan zaɓi sabon takamaiman takarda, sannan, riƙe maɓallin Ctrl danna dannawar da aka cika, a cikin waɗancan layin da ya juya ya zama wofi a cikin shafi da aka zaɓa. A wannan yanayin, zaɓi sama da sel ɗaya a jere. Don haka, matsayin matsayin zai nuna yawan duk layin da aka zaɓa wanda aƙalla sel ɗaya ya cika.
Amma akwai yanayi lokacin da ka zaɓi cike sel a cikin layuka, kuma nunin lamba akan sandar matsayin bai bayyana ba. Wannan yana nufin cewa wannan fasalin yana da rauni kawai. Don kunna shi, danna-dama akan masalin hali kuma a menu wanda ya bayyana, duba akwatin kusa da darajar "Yawan". Yanzu adadin layin da aka zaɓa zai bayyana.
Hanyar 2: yi amfani da aikin
Amma, hanyar da ke sama ba ta ba da damar gyara sakamakon ƙidaya a cikin takamaiman yanki akan takardar. Bugu da kari, yana bayar da dama don kirga kawai wadancan layin wadanda dabi'u suke a cikin su, kuma a wasu halaye ya wajaba a kirga dukkan abubuwan da ke hade, gami da wadanda ba komai. A wannan yanayin, aikin zai kai ga ceto KYAUTA. Syntax kamar haka:
= CIGABA (tsararru)
Ana iya tura shi cikin kowane ɓoyayyen tantanin halitta akan takardar, amma azaman hujja Shirya sauya gurbin daidaitawa daga cikin kewayon abin da kuke so ku ƙidaya.
Don nuna sakamako akan allon, danna kawai Shigar.
Haka kuma, koda gaba daya fankola layin za'a kidaya shi. Zai dace a lura cewa, sabanin hanyar da ta gabata, idan ka zaɓi yanki wanda ya haɗa da ginshiƙai da yawa, mai aiki zai yi layin kawai.
Yana da sauƙi ga masu amfani waɗanda ba su da ƙwarewa tare da dabaru a cikin Excel don yin aiki tare da wannan mai aiki ta hanyar Mayan fasalin.
- Zaɓi tantanin halitta wanda fitowar ƙidaya abubuwan za ta kasance. Latsa maballin "Saka aikin". Tana nan da nan zuwa hagu na masarar dabara.
- Karamin taga yana farawa Wizards na Aiki. A fagen "Kategorien" saita matsayin Tunani da Arrays ko "Cikakken jerin haruffa". Neman darajar SAURARA, zaɓi shi kuma danna maballin "Ok".
- Farashin muhawara na aiki zai bude. Sanya siginan kwamfuta a cikin filin Shirya. Zabi kewayon a kan takardar, yawan layin da kake son kirgawa. Bayan an daidaita yanayin wannan yankin a fagen muhawara, sai a latsa maballin "Ok".
- Shirin yana aiwatar da bayanan kuma yana nuna sakamakon kirga layuka a cikin tantanin da aka ƙayyade. Yanzu za a nuna wannan jimlar a cikin wannan yankin koyaushe, idan ba ku yanke shawarar share shi da hannu ba.
Darasi: Mayan Maɗaukaki
Hanyar 3: amfani da tacewa da kuma tsara yanayin
Amma akwai wasu lokuta waɗanda wajibi ne don yin lissafin ba duk layuka a cikin kewayo ba, amma waɗanda suka dace da wani yanayin da aka ba su. A wannan yanayin, tsari mai mahimmanci da kuma matattara mai zuwa za su kasance a ceto
- Zaɓi kewayon da za'a bincika yanayin.
- Je zuwa shafin "Gida". A kan kintinkiri a cikin akwatin kayan aiki Salo danna maballin Tsarin Yanayi. Zaɓi abu Dokokin Zabi na Cell. Na gaba, abu na dokoki daban-daban ya buɗe. Ga misalinmu, mun zaɓi "...Ari ...", dukda cewa ga wasu halaye ana iya tsayar da zabi a wani wuri daban.
- Taka taga yana buɗe abin da aka saita yanayin. A filin hagu, saka lamba, ƙwayoyin da suka haɗa da darajar da suka fi girma wanda za'a fentin su a wani launi. A cikin filin dama, yana yiwuwa a zaɓi wannan launi, amma kuna iya barin ta ta tsohuwa. Bayan an kammala yanayin, sai a danna maballin "Ok".
- Kamar yadda kake gani, bayan waɗannan ayyuka ƙwayoyin waɗanda ke gamsar da yanayin sun cika ambaliya tare da launi da aka zaɓa. Zaɓi duk kewayon dabi'u. Kasancewa a cikin komai iri ɗaya "Gida"danna maballin Dadi da kuma Matatarwa a cikin rukunin kayan aiki "Gyara". Cikin jeri wanda ya bayyana, zaɓi "Tace".
- Bayan haka, alamar tacewa ta bayyana a kan taken shafi. Mun danna shi a cikin shafin inda aka yi wa tsara tsara kaya. A menu na buɗe, zaɓi "Tace ta launi". Bayan haka, danna kan launi da ya cika nau'in sel waɗanda ke gamsar da yanayin.
- Kamar yadda kake gani, sel ba'a yiwa alama mai launi bayan an ɓoye waɗannan ayyukan. Kawai zaban ragowar sel kuma kalli mai nuna alama "Yawan" a cikin matsayin matsayin, kamar yadda a warware matsalar a farkon hanya. Wannan lambar ce zata nuna adadin layuka da suka gamsar da wani yanayi.
Darasi: Tsarin yanayi a cikin Excel
Darasi: A ware da kuma tace bayanai a cikin Excel
Kamar yadda kake gani, akwai hanyoyi da yawa don gano adadin layin da aka zaɓa. Kowace ɗayan waɗannan hanyoyin sun dace da takamaiman dalilai. Misali, idan kuna son gyara sakamakon, to a wannan yanayin zabin tare da aiki ya dace, kuma idan aikin shine a kirga layin da ya dace da wani yanayin, to tsari na tsari tare da tace mai zuwa zai zo ga ceto.
