Zamkatimu
Dzulo pa marathon 30 Excel imagwira ntchito m'masiku 30 tinazindikira mitundu ya zolakwika pogwiritsa ntchito ntchitoyi ERROR.TYPE (ERROR TYPE) ndikuwonetsetsa kuti zitha kukhala zothandiza kwambiri pakuwongolera zolakwika mu Excel.
Pa tsiku la 18 la marathon, tidzapereka phunziro la ntchitoyi FUFUZANI (FUFUZANI). Imayang'ana zilembo (kapena zilembo) mkati mwachingwe ndikuwonetsa komwe idapezeka. Tiwonanso momwe tingathanirane ndi zochitika zomwe ntchitoyi iponya zolakwika.
Choncho, tiyeni tione mwatsatanetsatane chiphunzitso ndi zitsanzo zothandiza za ntchitoyi FUFUZANI (FUFUZANI). Ngati muli ndi zidule kapena zitsanzo zogwirira ntchito ndi ntchitoyi, chonde gawanani nawo mu ndemanga.
Ntchito 18: FAKA
ntchito FUFUZANI (SEARCH) amafufuza zingwe za mawu mkati mwa zingwe zina, ndipo ngati atapezeka, amafotokoza momwe alili.
Kodi ndingagwiritsire ntchito bwanji SEARCH?
ntchito FUFUZANI (SEARCH) amafufuza zingwe za mawu mkati mwa zingwe zina. Akhoza:
- Pezani mndandanda wamawu mkati mwachingwe china (chopanda kanthu).
- Gwiritsani ntchito zilembo zakutchire pakufufuza kwanu.
- Tsimikizirani malo oyambira pamawu omwe awonedwa.
SEARCH Syntax
ntchito FUFUZANI (SEARCH) ili ndi mawu awa:
SEARCH(find_text,within_text,[start_num])
ПОИСК(искомый_текст;текст_для_поиска;[нач_позиция])
- kupeza_lemba (search_text) ndiye mawu omwe mukuyang'ana.
- mkati_mawu (text_for_search) - chingwe cha mawu momwe kusaka kumachitikira.
- chiyambi_nambala (start_position) - ngati sizinatchulidwe, kusaka kumayambira pamunthu woyamba.
Misampha SEARCH (SEARCH)
ntchito FUFUZANI (KUFUFUZA) kubweretsanso malo a chingwe choyamba chofananira, chopanda chidwi. Ngati mukufuna kusaka kosavuta, mutha kugwiritsa ntchito ntchitoyi DZIWANI (PEZANI), zomwe tidzakumane nazo pambuyo pake mu marathon 30 Excel imagwira ntchito m'masiku 30.
Chitsanzo 1: Kupeza mawu m’chingwe
Gwiritsani ntchito function FUFUZANI (FUFUZANI) kuti mupeze mawu mkati mwa zingwe. Muchitsanzo ichi, tikhala tikuyang'ana munthu m'modzi (wojambulidwa mu cell B5) mkati mwa zingwe zopezeka mu cell B2.
=SEARCH(B5,B2)
=ПОИСК(B5;B2)
Ngati malemba apezeka, ntchito FUFUZANI (SEARCH) ibweza nambala yamalo a chilembo chake choyamba muzolemba. Ngati sichipezeka, zotsatira zake zidzakhala uthenga wolakwika #VALUE! (#SO).
Ngati zotsatira zake ndi zolakwika, mutha kugwiritsa ntchito ntchitoyi IFERROR (IFERROR) kotero kuti m'malo mochita ntchitoyi FUFUZANI (SEARCH) onetsani uthenga wofananawo. Ntchito IFERROR (IFERROR) idayambitsidwa mu Excel kuyambira mu 2007. M'matembenuzidwe akale, zotsatira zomwezi zitha kupezeka pogwiritsa ntchito IF (IF) pamodzi ndi ISERROR (EOSHIBKA).
=IFERROR(SEARCH(B5,B2),"Not Found")
=ЕСЛИОШИБКА(ПОИСК(B5;B2);"Not Found")
Chitsanzo 2: Kugwiritsa ntchito zikwangwani zokhala ndi SEARCH
Njira ina yowonera zotsatira zabwerera FUFUZANI (FUFUZANI), pakulakwitsa - gwiritsani ntchito ntchitoyi ISNUMBER (ISNUMBER). Ngati chingwe chapezeka, zotsatira zake FUFUZANI (SEARCH) idzakhala nambala, kutanthauza ntchito ISNUMBER (ISNUMBER) ibwerera TRUE. Ngati malembawo sanapezeke, ndiye FUFUZANI (SEARCH) adzanena cholakwika, ndi ISNUMBER (ISNUMBER) ibweza FALSE.
Mu mtengo wa mkangano kupeza_lemba (search_text) mutha kugwiritsa ntchito zilembo zakutchire. Chizindikiro * (asterisk) imalowetsa nambala iliyonse ya zilembo kapena ayi, ndi ? (chizindikiro) chimalowa m'malo mwa munthu mmodzi.
Mu chitsanzo chathu, mawonekedwe a wildcard amagwiritsidwa ntchito *, kotero mawu akuti CENTRAL, CENTER, ndi CENTER apezeka m'mayina amisewu.
=ISNUMBER(SEARCH($E$2,B3))
=ЕЧИСЛО(ПОИСК($E$2;B3))
Chitsanzo 3: Kudziwa pomwe poyambira UPWANI (FUFUKWA)
Ngati tilemba zizindikiro ziwiri zochotsera (kutsutsa kawiri) kutsogolo kwa ntchitoyi ISNUMBER (ISNUMBER), ibweza makonda 1/0 m'malo mwa ZOONA/BODZA (ZOONA/BODZA). Kenako, ntchito SUM (SUM) mu selo E2 idzawerengera chiwerengero chonse cha zolemba zomwe mawu osaka adapezeka.
Muchitsanzo chotsatirachi, gawo B likuwonetsa:
Dzina la mzinda | Ntchito
Ntchito yathu ndikupeza akatswiri omwe ali ndi zingwe zolembedwa mu cell E1. Fomula mu cell C2 ingakhale:
=--ISNUMBER(SEARCH($E$1,B2))
=--ЕЧИСЛО(ПОИСК($E$1;B2))
Chilinganizo ichi chinapeza mizere yomwe ili ndi mawu akuti "banki", koma m'modzi mwa iwo mawuwa sapezeka m'dzina la ntchitoyo, koma m'dzina la mzinda. Izi sizoyenera kwa ife!
Dzina la mzinda uliwonse limatsatiridwa ndi chizindikiro | (monga bar), kotero ife, pogwiritsa ntchito ntchitoyi FUFUZANI (FUFUZANI), titha kupeza malo omwe munthuyu ali. Malo ake akhoza kufotokozedwa ngati mtengo wa mkangano chiyambi_nambala (start_position) mu "main" ntchito FUFUZANI (FUFUZANI). Zotsatira zake, mayina amizinda sadzanyalanyazidwa ndikusaka.
Tsopano fomula yoyesedwa ndikuwongolera ingowerengera mizere yomwe ili ndi mawu oti "banki" m'dzina la ntchitoyo:
=--ISNUMBER(SEARCH($E$1,B2,SEARCH("|",B2)))
=--ЕЧИСЛО(ПОИСК($E$1;B2;ПОИСК("|";B2)))