Kana iwe uchida karenda paMicrosoft Excel sheet, saka une nzira dzakawanda dzakasiyana - kubva nekurwadziwa kupinda misi nemaoko kusvika pakubatanidza pop-up makarenda kubva kwakasiyana maadd-ons uye macros. Imwe sarudzo ndeyekushandisa karenda yepasirese kune chero zuva uchishandisa imwe chete (kunyangwe ichityisa zvakanyanya kubva mutsika) array formula.
Kuti uishandise, gadzira isina chinhu pane pepa seizvi:
Zuva iri muchitokisi B2 rinogona kuva chero chinhu, mwedzi negore chete zvakakosha pano. Masero ari muchikamu B3:H3 anogona kuva nemazita emazuva evhiki mune chero chimiro chakakodzera.
Zvino sarudza iyo B4: H9 uye isa inotevera fomula ipapo:
=ЕСЛИ(МЕСЯЦ(ДАТА(ГОД(B2);МЕСЯЦ(B2);1)) <>МЕСЯЦ(ДАТА(ГОД(B2);МЕСЯЦ(B2);1)- (ДЕНЬНЕД(ДАТА(ГОД(B2);МЕСЯЦ(B2);1);2)-1) +{0:1:2:3:4:5}*7+{1;2;3;4;5;6;7}-1);» «; ДАТА(ГОД(B2);МЕСЯЦ(B2);1)- (ДЕНЬНЕД(ДАТА(ГОД(B2);МЕСЯЦ(B2);1);2)-1) +{0:1:2:3:4:5}*7+{1;2;3;4;5;6;7}-1)
Mushanduro yeChirungu ichave:
=IF(MONTH(DATE(YEAR(B2),MONTH(B2),1)) <>MONTH(DATE(YEAR(B2),MONTH(B2),1)- (WEEKDAY(DATE(YEAR(B2),MONTH(B2),1))-1) +{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),””, DATE(YEAR(B2),MONTH(B2),1)- (WEEKDAY(DATE(YEAR(B2),MONTH(B2),1))-1) +{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)
Wobva warova musanganiswa Ctrl + Shift + Pindakuisa iyi fomula seyakarongwa fomula. Masero ese akasarudzwa anofanirwa kuzadzwa nemazuva emwedzi anotsanangurwa muB2:
Chasara ndechekukwenenzvera chitarisiko nekuwedzera fomati uye kuvanza zuva mumusoro B2 uye mwedzi negore mune mamwe maseru uchishandisa hwindo. Fomati Masero (Ctrl+1):
Zvino, nekushandura zuva muchitokisi B2, isu tinowana iyo chaiyo karenda yemwedzi chero yakasarudzwa yegore ripi neripi zvinoenderana neforamu yedu. Inenge isingaperi karenda 😉
- Maitiro ekubatanidza popup karenda kune epamusoro sheet
- Kurumidza zuva uye nguva yekupinda neiyo PLEX yekuwedzera
- Iyo Excel inoshanda sei nemazuva uye nguva
- Kurumidza zuva uye nguva yekupinda pasina kupatsanura