Zamkatimu
Zoyeserera zimatipanga kukhala ngwazi.
(Flash)
Ngakhale chida Instant Fill (Flash Fill) adawonekera ku Excel kuyambira mtundu wa 2013, koma pazifukwa zina izi sizinadziwike kwa ogwiritsa ntchito ambiri. Ndipo mwamtheradi pachabe. Nthawi zambiri, zimakhala zosavuta, zosavuta komanso zachangu kuposa njira zofananira potengera ma formula kapena ma macros. Muzochitika zanga, m'maphunziro, mutuwu umayambitsa "wow!" omvera - mosasamala kanthu za kupita patsogolo ndi / kapena kutopa kwa omvera.
Njira yogwiritsira ntchito chida ichi ndi yosavuta: ngati muli ndi mizati imodzi kapena zingapo zomwe zili ndi deta yoyambirira ndipo mukuyamba kuzilemba pafupi ndi mzake mugawo lotsatira, koma muzosinthidwa zina zomwe mukufuna, ndiye kuti posachedwa Excel idzawonetsa izo. yakonzeka kupitilira kupitirira inu:
Kuti awulule malingaliro (chitsanzo, mawonekedwe) akusintha ndikuyendetsa ntchito ya Excel, nthawi zambiri kumakhala kokwanira kuyika pamanja zoyambira 1-3 zoyambira. Ngati njira yomwe yaperekedwa ikuyenererani, ingodinani Lowani - ndipo mndandanda wonsewo udzamalizidwa nthawi yomweyo.
Ngati mwalowa kale zikhalidwe zoyamba za 2-3, ndipo kupitilizabe sikukuwoneka, ndiye kuti mutha kukakamiza njirayi ndi njira yachidule ya kiyibodi. Ctrl+E kapena kugwiritsa ntchito batani Instant Fill (Flash Fill) tsamba Deta (Tsiku):
Tiyeni tiwone zitsanzo zingapo za momwe chida ichi chingagwiritsire ntchito pochita kuti timvetsetse luso lake.
Kutulutsa mawu m'malemba ndi zovomerezeka
Kulemba chilinganizo chomwe chimachotsa, mwachitsanzo, liwu lachitatu kuchokera palemba lomwe lili muselo si ntchito yaing'ono. Sinthani mawu ndi danga m'magawo osiyanasiyana pogwiritsa ntchito Deta - Zolemba ndi Mizati (Deta - Zolemba ku Mizati) Komanso si mofulumira. Ndi kudzaza pompopompo, izi zimachitika mosavuta komanso mokongola. Komanso, mutha kusintha nthawi imodzi mawu ochotsedwa m'malo, kuwaphatikiza mwanjira iliyonse:
Kugawa mawu ndi kaundula
Kuti muwonetsere mawu kuti mudzaze nthawi yomweyo, sikofunikira kukhala ndi malo. Chotsitsa china chilichonse chidzagwira ntchito bwino, ngati comma kapena semicolon mutalowetsa fayilo ya CSV. Koma chomwe chili chosangalatsa ndichakuti mwina sipangakhale olekanitsa - zilembo zazikulu zokha ndizokwanira:
Ndizovuta kwambiri kugwiritsa ntchito njira zoterezi. Ngati popanda kudzazidwa pompopompo, ndiye kuti macro okha ndi omwe angathandize.
Kumanga mawu
Ngati mutha kugawa, ndiye kuti mutha kumata! Instant Fill idzakusonkhanitsirani mawu aatali kuchokera kuzidutswa zingapo, kuwaphatikiza ndi malo ofunikira, ma comma, migwirizano kapena mawu:
Kuchotsa zilembo payekha
Nthawi zambiri, kuti mutulutse zilembo zamtundu uliwonse ndi zingwe mu Excel, ntchito zimagwiritsidwa ntchito LEVSIMV (Kumanzere), ZABWINO (KUKWERA), Zithunzi za PSTR (pakati) ndi zina zotero, koma kudzazidwa pompopompo kumathetsa vutoli mosavuta. Chitsanzo chodziwika bwino ndikupangidwa kwa dzina lonse:
Chotsani manambala, malemba kapena madeti okha
Ngati munayesapo kutulutsa mtundu womwe mukufuna kuchokera pa phala la alphanumeric, ndiye kuti muyenera kumvetsetsa zovuta za ntchitoyi yomwe ikuwoneka ngati yosavuta. Kudzazidwa pompopompo ndipo apa kukulimbana ndi kuphulika, koma mukufunikira penel yowala mu mawonekedwe Ctrl+E:
Momwemonso ndikuchotsa zolemba.
Madeti nawonso alibe vuto (ngakhale atalembedwa m'njira zosiyanasiyana):
Kutembenuza nambala kapena mawonekedwe amasiku
Kudzaza kwa Flash kumatha kuthandizira kusintha mawonekedwe a zomwe zilipo kale kapena kuzibweretsa kumtundu womwewo. Mwachitsanzo, kusintha tsiku lokhazikika la "topsy-turvy" kukhala mtundu wa Unix:
Apa chodabwitsa ndichakuti musanalowe, muyenera kusintha mawonekedwe a maselo omwe atuluka kuti alembe pasadakhale kuti Excel isayese kuzindikira masiku "olakwika" omwe adalowetsedwa pamanja ngati chitsanzo.
Momwemonso, mutha kuyimiranso manambala a foni molondola powonjezera nambala yadziko ndi choyambira cha manambala atatu (mzinda) m'mabulaketi:
Musaiwale kusintha kaye mawonekedwe a maselo omwe ali mugawo B kukhala mawu - apo ayi Excel idzatenga ma XNUMXbuXNUMXbkuyamba ndi chikwangwani cha "+" ngati mafomula.
Sinthani mawu (manambala) kuti akhale pano
Mukatsitsa kuchokera pamakina osiyanasiyana a ERP ndi CRM, tsikuli nthawi zambiri limayimiridwa ngati nambala ya manambala 8 mumtundu wa YYYYMMDD. Mutha kuyisintha kukhala mawonekedwe abwinobwino ndi ntchitoyo DATA IDENTIFIER (DATEVALUE), kapena zosavuta - kudzaza pompopompo:
Sinthani mlandu
Ngati muli ndi mawu omwe ali ndi vuto lolakwika, ndiye kuti mutha kulozera mgawo lotsatira mtundu womwe mukufuna kuwasinthira - ndipo kudzaza pompopompo kukuchitirani zonse:
Zidzakhala zovuta pang'ono ngati mukufuna kusintha nkhaniyo mosiyana ndi zigawo zosiyanasiyana za malemba. Mwachitsanzo, tchulani zilembo zazikulu mawu achiwiri okha, kusiya woyamba m'mawonekedwe ake. Apa, zikhalidwe ziwiri zomwe zidalowetsedwa ngati zitsanzo sizikhala zokwanira ndipo muyenera kusintha zomwe kudzaza pompopompo kumaganizira zotsatira zake:
Zolepheretsa ndi ma nuances
Pali zinthu zingapo zomwe muyenera kukumbukira mukamagwiritsa ntchito Flash Fill muntchito yanu:
- Zimagwira ntchito ngati lowetsani zitsanzo mosamalitsa mbali ndi mbali - m'gawo lapitalo kapena lotsatira kumanja kwa deta. Ngati mubweza ndime imodzi yopanda kanthu kuchokera pamawu oyamba, ndiye kuti palibe chomwe chingagwire ntchito.
- Pamene chitsanzo chikupezeka mfundo zonse motsatana zimaganiziridwa - kumanzere ndi kumanja kwa gawo lolowera. Makhalidwe: magawo owonjezera omwe amatha kusokoneza ma aligorivimu kapena kuyambitsa phokoso ayenera kulekanitsidwa ndi zomwe zikugwira ntchito pasadakhale ndi mizati yopanda kanthu kapena kufufutidwa.
- Instant Fill imagwira ntchito bwino pama tebulo anzeru.
- pang'ono pokha cholakwika kapena typo pamene kulemba zitsanzo za maselo kungayambitse kudzaza kwa flash kulephera kuwulula chitsanzocho ndi kusagwira ntchito. Samalani.
- Pali zochitika zomwe template imatanthauzidwa molakwika, choncho nthawi zonse muyenera kufufuza zotsatirazomwe mudalandira (osasankha).
- Momwe mungatulutsire liwu lomaliza palemba mu cell
- Fuzzy Text Search (Pushkin = Pushkin) yokhala ndi Fuzzy Lookup mu Excel
- Njira zitatu zoyika mawu mu Excel