Samar da matsala
Bari mu ɗauka cewa muna buƙatar ƙirƙirar saitin lambobi bazuwar ba tare da maimaitawa ba a cikin kewayon ƙima. Misalai akan tafiya:
- samar da keɓaɓɓen lambobin bazuwar don samfura ko masu amfani
- sanya mutane zuwa ayyuka (kowane ɗayan bazuwar daga jerin)
- karkatar da kalmomi a cikin tambayar neman (hello seo-shnikam)
- wasa lotto da dai sauransu.
Hanyar 1. Sauƙi
Don fara da, bari mu yi la'akari da wani zaɓi mai sauƙi: muna buƙatar samun bazuwar saitin lamba 10 daga 1 zuwa 10. Yin amfani da aikin da aka gina a cikin Excel. TSAKANIN AL'AMARIN (GABA TSAKANIN) keɓantacce ba ta da garanti. Idan ka shigar da shi a cikin tantanin halitta kuma ka kwafa shi ƙasa sel guda 10, to maimaitawa na iya faruwa cikin sauƙi:
Saboda haka, za mu bi ta wata hanya.
Duk nau'ikan Excel suna da aiki RANK (RANG), an yi niyya don matsayi ko, a wasu kalmomi, ƙayyade matsayi na saman lamba a cikin saiti. Lamba mafi girma a cikin jerin yana da matsayi = 1, na biyu a saman yana da matsayi = 2, da sauransu.
Bari mu shigar da aikin a cikin cell A2 SLCHIS (RAND) ba tare da gardama ba kuma kwafi dabarar ƙasa sel 10. Wannan aikin zai samar mana da saitin lambobi 10 bazuwar lambobi daga 0 zuwa 1:
A shafi na gaba muna gabatar da aikin RANKdon tantance matsayi a cikin kima don kowane lambar da aka karɓa:
Muna samun a shafi na B abin da muke so - kowane adadin da ba a maimaita ba daga 1 zuwa 10.
A bisa ka'ida, yanayi na iya tasowa lokacin SLCHIS za su ba mu lambobi guda biyu iri ɗaya a shafi na A, darajarsu za ta yi daidai kuma za mu sami maimaituwa a shafi na B. Duk da haka, yuwuwar irin wannan yanayin yana da ƙanƙanta, idan aka yi la'akari da cewa daidaiton wurare 15 ne.
Hanyar 2. Rikici
Wannan hanya ta ɗan fi rikitarwa, amma tana amfani da dabarar tsararru ɗaya kawai. Bari mu ce muna buƙatar ƙirƙirar jerin ƙididdiga na bazuwar 9 marasa maimaitawa a cikin kewayon daga 1 zuwa 50 akan takarda.
Shigar da wannan dabara a cikin cell A2, danna a karshen Ctrl + Shigar + Shigar (don shigar da shi azaman dabarar tsararru!) da kwafi dabarar zuwa adadin da ake so na sel:
Hanyar 3. Macro
Kuma, ba shakka, zaku iya magance matsalar ta amfani da shirye-shirye a cikin Visual Basic. A cikin ɗaya daga cikin tsofaffin labaran game da samfurin bazuwar, Na riga na ambata aikin macro na Lotto array, wanda ke samar da adadin da ake buƙata na lambobi marasa maimaitawa daga tazara da aka bayar.
- Yadda ake ƙirga adadin ƙima na musamman a cikin kewayo
- Zaɓin bazuwar abubuwa daga jeri