Yadda za a yi amfani da Excel String Compare aiki?

Yi Amfani da stringan murfin Excel da kyau

Yin amfani da MS Excel a matsayin maganin yau da kullun, na iya sa rayuwarku ta fi sauƙi. Babu damuwa inda kake aiki, hanyar da Excel ke aiki, zata fitar maka da matsala, tare da wadatattun ayyuka masu sauƙin amfani don ƙidaya yawan abin da ya faru, neman matsayin halaye a cikin kirtani, ƙidaya lambobi a cikin sel ko lissafa haruffa a cikin tantani misali.

Amma Excel yana da fasalin ban sha'awa wanda yafi sauƙin aiki tare da fiye da kowane software a zamanin yau. Zai baka damar kwatanta kirtani guda biyu ka ga ko suna da kama ko sun sha bamban da juna.

# 1 Yaya za ku kwatanta hanyoyi guda biyu don kamance a cikin Excel?

Idan kana son sanin ko sel guda biyu suke, wanda shine sigar lissafi mafi sauƙin sauye sauye, zaku yi amfani da aikin EXACT.

Babu matsala idan akwai lambobi ko kalmomi ko jumla. Wannan aikin zai bincika sel waɗanda kake son aiwatar da daidaitaccen aikin String.

Abin da kawai za ku yi shine danna kan wayar da kuke son samun sakamakon. Bayan haka, danna kan shafin dabarar, wanda ke saman sel. A shafin dabarar zaka rubuta aikin da zakuyi aiki tare.

Ba lallai ba ne a bincika ayyukan cikin saitunan ayyuka. Kuna iya koyan kaɗan daga cikinsu don haka aikin zai yi sauri.

A wannan shafin zaka sanya alamar daidai a gaban kowane aiki. Don haka zai kasance kamar haka:

Excel String kwatanta hali: = EXACT

Misali. Bari mu ce C1 shine 'kankana' kuma C5 shine '' Kankana '.

Ayyukan don yin daidai daidai misalin abin da ya dace ya kwatanta:

Ainihin yanayin abin da ya shafi ƙwaƙwalwar ƙwaƙwalwar ƙwaƙwalwar ƙwayar cuta kwatanta: = EXACT (C1, C5)

A tantanin da kuka zaɓi don samun sakamako, Exact zai juya zuwa GASKIYA ko FALSE, ya danganta da abin da kuke son kwatantawa.

A cikin lamarinmu zai zama sakamako mai kyau, saboda yanayin ya bambanta, kuma aikin EXACT shine yanayin kulawa. Idan kana son kwatanta 'Green' da 'Green', komfuta zata san cewa ma areayoyin iri ɗaya ne kuma zaka sami sakamako na GASKIYA.

Kasance mai kyau Pro: Kasance da karatunmu!

Daukaka kwarewarku daga novice ga gwarzo tare da muxin muxinmu na 365, wanda aka tsara don sanya ku ƙwarewa a cikin 'yan zaman a cikin' yan zaman.

Rijista a nan

Kuna iya samun tambaya - abin da za ku yi don Excel Idan igiyoyin daidai suke. Sau da yawa, Ayyukan Excelets sun ƙunshi bayanan kwafi waɗanda aka kwafa sau da yawa. Amma maimaitawa ba koyaushe yana nuna kuskuren shiga bayanai ba. Wani lokacin maimaita shigarwar tare da dabi'un guda ɗaya an yi shi da gangan. Sannan matsalar na iya tashi lokacin aiki, bincika bayanai ko nazarin a cikin irin wannan tebur.

Don sauƙaƙe muku aiki tare da irin wannan tebur, muna ba da shawarar cewa ka haɗu da layuka iri ɗaya ta atomatik ta nuna musu launi. Ga mai sauki amma aiki mai aiki.

Koyaya, ba lallai ne ka damu da sakamakon ba saboda software na Excel koyaushe zai yi daidai. Kawai ka kula ka yi amfani da aikin da kake buƙata don aikin da kake son aiwatarwa, a cikin yanayinmu ƙimar madaidaiciyar madaidaiciyar kwatancen tsakanin sel biyu.

# 2 Kwatanta kirtani guda biyu tare da darajar dawo da kai na mutum

Kuna iya tsara amsoshin da zaku samu akan wayar. Madadin samun GASKIYA ko FASAHA, zaka iya samun YES ko KADA. Amma saboda hakan kuna buƙatar ƙarin aiki, wanda shine aikin IF.

Kwatanta ƙira biyu tare da darajar dawowar al'ada: = IF (EXACT (C1, C5), "Ee", "KADA")

Hakanan, kar a manta amfani da alamun ambaton lokacin da ba ku amfani da aiki ko lambobin ƙwayoyin cuta.

# 3 Yadda za a kwatanta yanayi guda biyu masu raunin gani a cikin Excel?

Koyaya, aikin EXACT shine yanayin da yake damuwa kuma akwai wata hanya mai sauƙi. Ka manta game da wannan aikin zaka iya amfani da alamar daidai azaman aiki mai tsabta.

Excel string string case insensitive: = C1 = C5

Zai zama da wuya a gwada sel tsakanin su ba tare da kula da ƙananan ko babban Babu matsala idan kuna rubuta WaTErmelon ko kankana kawai saboda wannan kayan aiki na MS zai tabbatar da abun cikin kirtani sannan zai sami sakamako daidai.

A takaice, yadda ake yin cikakken aikin String kwatanta

Tabbas, akwai hanyoyi da yawa don kwatanta kirtani guda biyu a cikin MS Excel. Amma yana buƙatar sanin kadan na lambar. Kuma ba kowa bane yana da lokaci don koyan hanyar lambar yayin amfani da Excel don aiki. Don haka, a ƙarshe, wannan ita ce hanya madaidaiciya don samun sakamako daidai don bukatunku.

Excel kirtaccen kwatancen yanayi mai mahimmanci: = EXACT (C1, C5)

Excel string string case insensitive: = C1 = C5

Ku ci gaba da tafiya da ma'anar zaren MSExcel kamar ƙidaya adadin abin da ya faru, sami matsayin halayyar a cikin kirtani, ƙidaya lambobi a cikin sel, ko ƙididdige haruffa a cikin sel yanzu kun kware kwatancen kirtani a cikin shirin da kuka fi so, MSExcel.

Tambayoyi Akai-Akai

Wace hanya ce za a yi amfani da shi don kwatanta kirtani guda biyu cikin fice, ba da izinin kwatancen-mai rikitarwa ko ƙa'idodi?

Yi amfani da `` exact ((Text1, Text2) Lissafin ƙwaƙwalwar ƙwaƙwalwa, wanda ya dawo gaskiya idan igiyoyin daidai yake, ciki har da lamarin, da kuma karya. Don kwatancen abubuwa-rashin tsaro, yi amfani da `= rubutu1 = Text2` Syntax, wanda ya ƙididdige gaskiya idan zaren ya dace, ya yi watsi da batun.

Cikakken 2019 Excel ga Masu farawa a bidiyo