Uzifumana njani iiseli eziphindiweyo kwiphepha le-Excel

Omnye wemisebenzi yakudala yokufumana iimpazamo okanye ukucoca ifayile ye-Excel kukukhangela iiseli eziphindiweyo.

Kukho iindlela ezininzi zokufumana iiseli eziphindiweyo, kweli nqaku siza kujonga iindlela ezimbini ezilula zokufumana kunye nokuqaqambisa iiseli eziphindiweyo kwispredishithi se-Excel.

Fumana iiseli eziphindwe kabini kwi-Excel

Ukubonisa indlela yokufumana iiseli eziphindiweyo kwi-Excel, masisebenzise i-spreadsheet esilula esingezantsi, esinoluhlu lwamagama kuluhlu A.

Masiqale sibonise indlela yokusebenzisa ukufomatha okunemiqathango ukuqaqambisa iiseli eziphindiweyo, emva koko sibonise ukuba njani sebenzisa umsebenzi Countif yeExcel ukufumana impinda.

Phawula iiseli eziphindiweyo usebenzisa ukufomatha okunemiqathango

Ukufumana iiseli eziphindiweyo ezinofomatho olunemiqathango, landela la manyathelo angezantsi:

• Khetha uluhlu lweeseli oza kufomatha.
• Khetha iMenu yokuhla yokuFomatha uMqathango kwithebhu yaseKhaya phezulu kwincwadi yakho yokusebenza ye-Excel. Ngaphakathi kule menyu:
  • Khetha ukhetho Gxininisa imithetho yeseli kwaye, kwimenyu yesibini evelayo, khetha i Amaxabiso ukhetho impinda… ;

• I-“Phinda amaxabiso“. Uluhlu oluhlayo kwicala lasekhohlo lale festile kufuneka ibonise ixabiso "Phinda kabini" (nangona oku kunokutshintshwa ukuze kuboniswe amaxabiso awodwa kuphela, kunokuphinda-phinda).

• Cofa ku OK .

Ukufomatha iiseli A2-A11 yomzekelo we-spreadsheet ngale ndlela ivelisa iziphumo ezilandelayo:

Fumana iimpinda usebenzisa Countif

Le ndlela iya kusebenza kuphela ukuba imixholo yeseli ingaphantsi koonobumba abangama-256 ubude, njengoko imisebenzi ye-Excel ayinakho ukuphatha imitya yokubhaliweyo emide.

Ukubonisa indlela yokusebenzisa i umsebenzi Countif Ukufumana impinda kwi-Excel, siya kusebenzisa umzekelo we-spreadsheet ngasentla, onoluhlu lwamagama aveza ikholamu A.

Ukufumana naziphi na iimpinda kuluhlu lwamagama, sifake umsebenzi Countif kumhlathi B wespreadsheet, ukubonisa inani lezehlo zegama ngalinye. Njengoko kubonisiwe kwibha yefomula, umsebenzi Countif esetyenziswa kwiseli B2 yi :=COUNTIF( A:A, A2 )

Lo msebenzi ubala inani lezenzeko zexabiso kwiseli A2 (igama “Adam SMITH”) ngaphakathi komhlathi A wespreadsheet.

Xa umsebenzi Countif ikhutshelwa kwikholam B yespreadsheet, iya kubala inani leziganeko zamagama kwiiseli A3, A4, njl.

Uyabona ukuba umsebenzi Countif ibuyisela ixabiso lika-1 kwimiqolo emininzi, ebonisa ukuba kukho isenzeko esinye kuphela samagama kwiiseli A2, A3, njl. Nangona kunjalo, xa kuziwa kwigama elithi "John ROTH", (elikhoyo kwiiseli A3 kunye ne-A8), umsebenzi ubuyisela ixabiso le-2, ebonisa ukuba kukho iziganeko ezimbini zeli gama.

Ercole Palmeri