Fumana iMilinganiselo yeMilinganiselo ne-Excel's Subtotal Feature

I-Excel's Subtotal feature isebenza ngokufaka umsebenzi we-SUBTOTAL kwisiseko sedata okanye uluhlu lweenkcukacha ezihambelanayo. Ukusebenzisa i-Subtotal feature yenza ukufumana nokukhipha ulwazi oluthile kwitafile enkulu yedatha ngokukhawuleza kwaye kulula.

Nangona ibizwa ngokuba "i-Subtotal feature", awukhawulelwanga ekufumaneni isisombululo okanye isixa semigca ekhethiweyo yedatha. Ukongeza kwi-totali, unokufumana ixabiso eliqhelekileyo kwikholam nganye okanye insimu yedatha kwisiseko sakho sedatha. Eli nyathelo ngetitshala lesibini liquka umzekelo wendlela yokufumana ixabiso eliqhelekileyo kwikholam ethile yedatha kwisiseko sedatha. Amanyathelo kule khosi:

1. Faka idatha yeTutorial
2. Ukuhlelwa kweSample Example
3. Ukufumana umlinganiselo wexabiso

01 ka 02

Faka iData yeTutorial Data

Faka iData yeTutorial Data

Qaphela: Ukuze uncedo ngale miyalelo ubone umfanekiso ongentla.

Isinyathelo sokuqala sokusebenzisa i-Subtotal feature kwi-Excel kukufaka idatha kwiphepha lokusebenzela .

Xa wenza njalo, gcina iingongoma ezilandelayo engqondweni:

• Kubalulekile ukungena idatha ngokuchanekileyo. Iimpazamo, ezibangelwa ukungena kwedatha engafanelekanga, ziyimvelaphi yeengxaki ezininzi ezinxulumene nokuphathwa kwedatha.
• Shiya akukho miqolo okanye iikholam ezingenanto xa ufaka idatha. Oku kubandakanya ukushiya umgca ongagqibekanga phakathi kwezihloko zekholomu kunye nomqolo wokuqala wedatha.

Kule khokelo:

Faka idatha kwiiseli A1 ukuya kwi-D12 njengoko kuboniswa kumfanekiso ongentla. Kulabo abangacingi ukuthayipha, idatha, imiyalelo yokuyikopisha kwi-Excel, iyafumaneka kulekhonkco.

02 we 02

Ukuhlela iDatha

Ukuhlela iDatha

Qaphela: Ukuze uncedo ngale miyalelo ubone umfanekiso ongentla. Cofa kumfanekiso ukuze ukwandise.

Ngaphambi kokuba iifowuni zingasetyenziselwa, idatha yakho kufuneka iqokelelwe ngekholomu yedatha ofuna ukukhipha ulwazi ukusuka kuyo. Olu qela lwenziwa ngokusebenzisa i-Excel's Sort feature .

Kule tutorial, sifuna ukufumana inani eliqhelekileyo learori nganye kwingingqi yokuthengisa ukwenzela ukuba idatha ihlelwe yi-column column heading.

Ukuhlenga iDatha ngoMmandla weNtengiso

1. Hudula ukhetha iiseli A2 ukuya kwi-D12 ukuze uzigqwezele. Qiniseka ukuba ungabandakanyi isihloko kwisigcawu esisodwa ekukhetheni kwakho.
2. Cofa kwiTebhu yedata yebhanethi .
3. Cofa kwiQhosha lokuHlaba eliphakathi kwidatha yedatha ukuvula ibhokisi yencoko yencoko .
4. Khetha Uhlobo ngeNqila ukusuka kuhlu oluhla-phantsi phantsi kweKholam ehamba kwibhokisi yencoko.
5. Qinisekisa ukuba idatha yam inehloko ihlolwe kwikhoneni eliphezulu lebhokisi yencoko.
6. Chofoza OK.
7. Idata kwiiseli ze-A3 ukuya kwi-D12 kufuneka ihlaziywe ngokwe-alfabhethi yimihlathi yesibini. Idatha yeempahla ezintathu zokuthengisa ezivela kummandla waseMpuma kufuneka zifakwe kuqala, zilandelwe nguMntla, ngokoMzantsi, kwaye zigcine indawo yaseNtshona.