Contents
ʻO ka pono e ʻike i nā waiwai kiʻekiʻe a haʻahaʻa loa i kekahi ʻoihana ʻike ʻia: nā huahana ʻoi aku ka maikaʻi a i ʻole nā mea kūʻai aku waiwai, nā moku nui a i ʻole nā mea hoʻouna, a pēlā aku.
Akā me kēia, i kekahi manawa pono ʻoe e nānā i ka ʻikepili ʻaʻole no ka luna, akā no nā waiwai i loaʻa pinepine ʻia, ʻoiai he ʻano like ia, ʻoiaʻiʻo, ʻaʻole like. E pili ana i kahi hale kūʻai, no ka laʻana, he ʻimi paha kēia i nā mea kūʻai pinepine ʻia, ma mua o nā mea waiwai loa, a i ʻole ka helu pinepine o nā mea i kahi kauoha, nā minuke i ke kamaʻilio ʻana, etc.
I loko o ia kūlana, pono e hoʻoponopono ʻia ka pilikia ma kahi ʻano ʻokoʻa, ma muli o ka mea a mākou e hana nei - nā helu a i ʻole kikokikona.
ʻImi ʻana i nā helu maʻamau
Inā mākou e kū nei i ka hana o ka nānā ʻana i ka ʻikepili i loaʻa i ke kūʻai ʻana i loko o kahi hale kūʻai i mea e hoʻoholo ai i ka nui o nā mea i kūʻai ʻia. No ka hoʻoholo ʻana i ka helu pinepine i ka laulā, hiki iā ʻoe ke hoʻohana i ka hana FASHION (? Aaeei):
ʻO ia, e like me kā mākou helu helu, kūʻai pinepine nā mea kūʻai aku i 3 pcs. waiwai.
Inā ʻaʻohe hoʻokahi, akā he nui nā waiwai i ka manawa hoʻokahi e like me ka helu kiʻekiʻe o nā manawa (he mau ʻano), a laila e ʻike iā lākou, hiki iā ʻoe ke hoʻohana i ka hana. FASHION.NSK (MODE.MULT). Pono e hoʻokomo ʻia ma ke ʻano he papa kuhikuhi, ʻo ia hoʻi, e koho i kekahi mau keena kaʻawale i ka manawa hoʻokahi, i lawa no nā ʻano a pau me kahi palena a komo i =MODA.NSK(B2:B16) i loko o ka pahu formula a kaomi i ka ʻaoʻao pōkole. Ctrl + Shift + Kākau.
Ma ka hopena, e loaʻa iā mākou kahi papa inoa o nā mods āpau mai kā mākou ʻikepili:
ʻO ia hoʻi, e hoʻoholo ana i kā mākou ʻikepili, lawe pinepine lākou ʻaʻole 3 wale nō, akā he 16 mau ʻāpana. waiwai. E ʻoluʻolu e hoʻomaopopo he ʻelua mau ʻano i kā mākou ʻikepili (3 a me 16), no laila, ʻo ke koena o nā cell i hoʻokaʻawale ʻia "ma ka mālama" me ka hewa #N/A.
ʻIke pinepine ʻia e nā pūʻulu me ka hana FREQUENCY
Inā pono ke kālailai ʻaʻole nā helu helu, akā nā helu hakina, a laila ʻoi aku ka pololei o ka loiloi ʻana ʻaʻole ka helu o nā waiwai like, akā hāʻule lākou i nā pae i kuhikuhi ʻia. No ka laʻana, pono mākou e hoʻomaopopo i ke kaumaha i kūʻai pinepine ʻia e nā waiwai i mea e koho ai i nā trolleys kūpono a me nā ʻeke ʻeke o ka nui kūpono no ka hale kūʻai. I nā huaʻōlelo ʻē aʻe, pono mākou e hoʻoholo i ka nui o nā helu i hāʻule i ka wā 1..5 kg, ehia i loko o ka wā 5..10 kg, etc.
No ka hoʻoponopono i kahi pilikia like, hiki iā ʻoe ke hoʻohana i ka hana alapine (frequency) (FREQUENCY). No ia mea, pono ʻoe e hoʻomākaukau i nā cell ma mua me nā manawa (pockets) o ka hoihoi iā mākou a laila koho i kahi ākea o nā cell (G2: G5) hoʻokahi cell i ʻoi aku ka nui o nā ʻeke (F2: F4) a hoʻokomo iā ia ma ke ʻano he kumu hoʻonohonoho ma ke kaomi ʻana i ka hui ma ka hopena Ctrl + Shift + Kākau:
Ka nānā 'ana i ka pinepine me ka papa pivot me ka hui 'ana
ʻO kahi hopena ʻē aʻe i ka pilikia: hana i kahi papa pivot kahi āu e kau ai i ke kaumaha o nā kūʻai ma ka wahi o nā lālani, a me ka helu o nā mea kūʻai aku ma nā wahi waiwai, a laila e hoʻopili i ka hui ʻana - kaomi-pololei i nā koina kaumaha a koho i ke kauoha Group (Puʻulu). Ma ka puka aniani e ʻike ʻia, hiki iā ʻoe ke hoʻonohonoho i nā palena a me ka pae hui:
… a ma hope o ke kaomi ʻana i ke pihi OK e kiʻi i kahi papaʻaina me ka helu o ka helu o nā mea kūʻai aku ma kēlā me kēia pūʻulu hui:
Con penei:
- hiki ke hoʻomau wale ka pae hui, ʻaʻole like me ka hana alapine (frequency), kahi e hiki ai ke kuhikuhi pono i na pockets
- Pono e hoʻonui ʻia ka papa pivot i ka wā e hoʻololi ai ka ʻikepili kumu (ma ke kaomi ʻana i ke pihi ʻiole ʻākau - Refresh), a helu ʻia ka hana ma ka lele.
E ʻimi i ka kikokikona e ʻike pinepine ʻia
Inā ʻaʻole mākou e pili ana i nā helu, akā me ka kikokikona, a laila e ʻokoʻa ke ʻano o ka hoʻonā. Inā paha he papaʻaina kā mākou me nā lālani 100 o nā mea i kūʻai ʻia ma kahi hale kūʻai a makemake mākou e hoʻoholo i nā mea i kūʻai pinepine ʻia?
ʻO ka hopena maʻalahi a maopopo loa ʻo ia ka hoʻohui ʻana i kahi kolamu ma hope o ka hana KĀNĀWAI (COUNTIF)no ka helu ʻana i ka helu o kēlā me kēia mea ma ke kolamu A:
A laila, ʻoiaʻiʻo, e hoʻokaʻawale i ke kolamu i loaʻa ma ke ʻano iho a nānā i nā laina mua.
A i ʻole e hoʻohui i kahi kolamu me nā mea i ka papa inoa kumu a kūkulu i kahi papa hōʻuluʻulu e pili ana i ka papa i hopena, e helu ana i ka huina o nā mea no kēlā me kēia huahana:
Inā ʻaʻole nui ka ʻikepili kumu a ʻaʻole makemake ʻoe e hoʻohana i nā papa pivot, a laila hiki iā ʻoe ke hoʻohana i ke ʻano hana:
E wāwahi mākou i kēlā me kēia ʻāpana:
- ʻO COUNTIF(A2:A20;A2:A20) he papa hoʻonohonoho e nānā ana i ka helu o nā hanana o kēlā me kēia huahana ma ka laulima A2:A100 a hoʻopuka i kahi pūʻulu me ka helu o ka hana hou ʻana i ka hopena, ʻo ia hoʻi, ʻoiaʻiʻo, pani i ke kolamu hou
- MAX – loaʻa ka helu nui loa i ka laha o nā hanana, ʻo ia hoʻi ka huahana i kūʻai nui ʻia
- MATCH – helu i ka helu ordinal o ka lālani ma ka pākaukau kahi i loaʻa ai iā MAX ka helu nui loa
- INDEX - hoʻihoʻi mai ka papa ʻaina i nā mea o ke kelepona me ka helu i loaʻa e MATCH
- Ke helu ʻana i ka helu o nā waiwai kūʻokoʻa i kahi papa inoa
- Ka unuhi ʻana i nā mea kūʻokoʻa mai kahi papa inoa pālua
- Ka hui ʻana i nā papa pivot