INDEX, MATCH, KHETHA - Izeluleko

0 1

Kugcinwe ukuvuselelwa ngo- by Raymond PENTIER
.

Kusetshenziswa yodwa, imisebenzi ye-INDEX ne-MATCH ayinasisekelo esikhulu; kepha kuhlobene, bavumela ucwaningo olumangazayo.

Umsebenzi wokukhetha, nokho okulula ukusetshenziswa, usetshenziswa omncane kakhulu.

Imisebenzi kuphela

Le misebenzi ichazwa kabanzi kuma-tutorials, izinkundla, amabhulogi, ukuqeqeshwa online. Kepha sikubone kufanele ukuthi sibahlanganyele ephepheni elilodwa elinombhalo. https://www.cjoint.com/c/JHbbkuHnIFB

————————— INDEX —->

————————— MATSHA--



UKUKHETHA -
Lo msebenzi usetshenziselwa ukubonisa inani ngokuya ngenombolo yenkomba:

= KHETHA (N °; val1; val2 ...)

Inani kufanele libe phakathi kuka-1 no-254; kukhetha impikiswano yenani okufanele ukhethe.

Inani lingaba ireferensi yeseli, ifomula, umbhalo, inombolo (yengxenyana, yonke le ngxenye) ...

Imisebenzi ehambisanayo

Ngokuhlanganisa imisebenzi, izinkinga eziningi ezahlukahlukene zingaxazululwa.

INDEX + MATCH

INDEX Vs EQUIV

Izinkambu eziningana

Ithebula elingaphelele

Amafayela ahlobene

Ungabheka kumashidi asebenzayo we-OFFSET:

I-OFFSET + INDEX + EQUIV + MIN --- 10 / 05 / 20

I-OFFSET, ene-INDEX ne-MATCH - 28 / 05 / 20

Lesi sihloko sivele kuqala TLC

Laisser un commentaire

Ikheli lakho le-imeyili ngeke lishicilelwe.