Skip i'r prif gynnwys

Hawdd dod o hyd i'r holl gyfuniadau sy'n hafal i swm penodol yn Excel

Awdur: Siluvia Wedi'i Addasu Diwethaf: 2020-08-24

Kutools ar gyfer Excel

Yn rhoi hwb i Excel Gyda 300+
Nodweddion pwerus

Gan dybio, mae rhestr o rifau (rhifau cyfan, rhifau degol neu rifau negyddol), ac yn awr, rydych chi am ddod o hyd i'r holl gyfuniadau posibl o'r rhifau hyn sy'n hafal i swm penodol. Fel rheol gallwch ddefnyddio fformwlâu, Ychwanegiad Datrysydd neu swyddogaeth wedi'i diffinio gan y Defnyddiwr i'w gyflawni, ond mae'n cymryd llawer o amser ac nid yw'n hawdd ei drin. Yma gyda'r defnyddiol Gwneud Rhif cyfleustodau Kutools ar gyfer Excel, ni fu dod o hyd i bob cyfuniad sy'n hafal i swm penodol erioed mor hawdd yn Excel.

Dewch o hyd i'r holl gyfuniadau sy'n hafal i swm penodol

Dewch o hyd i'r holl gyfuniadau sy'n hafal i swm penodol

Fel y dangosir y screenshot isod, i ddod o hyd i'r holl gyfuniadau posibl o rifau yn ystod B3: B11 sy'n dod i gyfanswm o 520, gallwch roi cynnig ar y cyfleustodau Make Up a Number fel a ganlyn.

1. Cliciwch Kutools > Cynnwys > Gwneud Rhif.

saethu colur rhif 03

2. Yn y Lluniwch rif blwch deialog, gwnewch y gosodiadau isod.

  • Yn y Ffynhonnell Data blwch, dewiswch y rhestr rifau i ddarganfod pa rifau sy'n adio i 520;
  • Yn y Dewisiadau adran, nodwch 520 yn yr Swm blwch testun;
  • Cliciwch ar y OK botwm. Gweler y screenshot:

3. Yn y nesaf Lluniwch rif blwch deialog, dewiswch gell i allbwn y cyfuniadau a chliciwch ar y OK botwm. Yna a Kutools ar gyfer Excel deialog yn ymddangos i ddweud wrthych faint o gyfuniadau fydd yn cael eu creu, cliciwch OK.

Gallwch weld bod yr holl gyfuniadau posibl o rifau dethol sy'n dod i gyfanswm o 520 wedi'u rhestru fel a ganlyn.

Nodiadau:

1. Mae'n ddewisol nodi nifer y cyfuniadau a nifer yr elfennau ym mhob cyfuniad yn lle cynhyrchu'r holl gyfuniadau. Fel y dangosir y screenshot isod, gallwch nodi nifer y cyfuniadau fel 4, a nodi nifer yr elfennau ym mhob cyfuniad o 1 i 4, yna, cewch y canlyniad canlynol:

Canlyniad:

2. Gellir cymhwyso'r nodwedd bwerus hon hefyd i rifau degol a negyddol, gweler y screenshot:

A byddwch yn cael y canlyniad fel y dangosir isod screenshot:

3. Gallwch wirio'r Cadwch ddalen newydd i mewn blwch i allbwn y cyfuniadau i ddalen newydd.

Dewch o hyd i'r holl gyfuniadau sy'n hafal i swm penodol

Kutools ar gyfer Excel yn cynnwys mwy na 300 o offer Excel defnyddiol. Am ddim i geisio heb unrhyw gyfyngiad mewn 30 diwrnod. Dadlwythwch y treial am ddim nawr!

Offer Cynhyrchaeth a Argymhellir
Gall yr offer canlynol arbed eich amser a'ch arian yn fawr, pa un sy'n iawn i chi?
Tab Swyddfa: Defnyddio tabiau defnyddiol yn eich Swyddfa, fel ffordd Chrome, Firefox a New Internet Explorer.
Kutools ar gyfer Excel: Mwy na 300 o Swyddogaethau Uwch ar gyfer Excel 2021, 2019, 2016, 2013, 2010, 2007 ac Office 365.

Kutools ar gyfer Excel

Dim ond un o swyddogaethau pwerus 300 o Kutools ar gyfer Excel yw'r swyddogaeth a ddisgrifir uchod.

Cynllun ar gyfer Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 ac Office 365. Dadlwythiad a defnydd am ddim am 30 diwrnod.

Llun sgrin o Kutools ar gyfer Excel

btn darllen mwy      btn lawrlwytho     prynu btn

Comments (19)
No ratings yet. Be the first to rate!
Giuseppe
Giuseppe
This comment was minimized by the moderator on the site
Is it possible to consider repetition of the same number as well?
For example:
numbers: 10 - 20 - 40
Given number: 90

Combination: 40 - 40 - 10

Thank you!
Reply
0
0
crystal
crystal     Giuseppe
This comment was minimized by the moderator on the site
Hi Giuseppe,

Sorry for the inconvenience. If your original data doesn't contain any duplicates, then duplicate values cannot be generated from it. Creating duplicate values for the same number would result in numerous combinations, which is generally not advisable due to complexity.
Reply
Report
0
0
tony
tony
This comment was minimized by the moderator on the site
I do not know about others, but I still have it.
Reply
0
0
Alex Ramaker
Alex Ramaker
This comment was minimized by the moderator on the site
There is no "Make up a number" under Content in my Kutools, has this feature been removed?
Reply
0
0
crystal
crystal     Alex Ramaker
This comment was minimized by the moderator on the site
Hi Alex Ramaker,
I am sorry for the inconvenience. Can you tell me which Kutools version are you using? If you can't find it under the Content group, please press the Alt + S keys to open the Kutools search box and type in "Make up a number", and then the feature name will be listed under the search box. Just click on it to activate the feature.
https://www.extendoffice.com/images/stories/comments/comment-picture-zxm/make_up_a_number.png
Reply
Report
0
0
Sylvia
Sylvia     crystal
This comment was minimized by the moderator on the site
I am also missing features in the Content section including Make Up a Number and Data Association and using Alt + S does not give me an option to search functions. Version is 19.0. Kutools was downloaded to my work machine through my organization's catalog, is it possible certain features are blocked?
Reply
0
0
crystal
crystal     Sylvia
This comment was minimized by the moderator on the site
Hi Sylvia,

The Make Up a Number feature was released in version 23.00 and the Data Association feature was released in version 25.00.
You are using an old version of Kutools and It’s the lifetime license with the 2-year free update support.
After the 2-year free update support, you cannot update to any new versions but you can still use the old versions of the software.
After the 2-year free update support, you will need to purchase a new version to use the features in the new version.
Reply
Report
0
0
Cathy
Cathy
This comment was minimized by the moderator on the site
The bug has not been fixed yet. Even though I select one output, and wait forever for the answer, I still get an error message stating that the tool can't handle more than 1,600+ answers. I did not ask for that many, I asked for *one*.
Reply
0
0
crystal
crystal     Cathy
This comment was minimized by the moderator on the site
Hi Cathy,
Sorry for the convenience and thanks for your support.
Our developers are working on upgrading this feature to have a better and fast way to deal with big data. And the new version will be released soon.
Please stay tuned for our updates!
Reply
Report
0
0
Tony
Tony
This comment was minimized by the moderator on the site
Was the bug fixed? What was great? Thank you.
Reply
0
0
otm2002
otm2002
This comment was minimized by the moderator on the site
This is so great, Thanks
Reply
Report
0
0
Tony
Tony
This comment was minimized by the moderator on the site
Same here. The function gets hung-up when searing more than 1000 numbers. I do see a progress bar, but it continues to get stuck at 6%. I have been using their products for close to a decade; it would be nice if they fixed/improved this. I was told to install latest version. I wouldn't know how to install anything other than the latest version.
Reply
0
0
crystal
crystal     Tony
This comment was minimized by the moderator on the site
Hi Tony,
Sorry for the convenience and thanks for your support for close to a decade.
Our developers are working on upgrading this feature to have a better and fast way to deal with big data, and it will be avaliable in the next release.
By the way, do the 1000+ numbers you used include positive numbers, negative numbers and decimal numbers? Do you mind send us the sample file for testing via ?
Reply
Report
0
0
HlepExcel
HlepExcel
This comment was minimized by the moderator on the site
Anyone able to get this to work? The Processing please wait is taking forever.. Don't want to cancel

Reply
0
0
LydiaLev
LydiaLev     HlepExcel
This comment was minimized by the moderator on the site
I'm having this problem! Did you get it to work?
Reply
Report
0
0
nealF
nealF
This comment was minimized by the moderator on the site
instead of "processing, please wait" it needs to have a counter which displays either how much time is estimated to be remaining to calculate or an actual counter of the calculations done and remaining to be counted. ie i have waited over 4 hours for the program to work out my 44C8 query (177m combinations) but i don't know whether the program has crashed or is still calculating.
Reply
Report
0
0
nealF
nealF     nealF
This comment was minimized by the moderator on the site
Still going after another 6 hours (10hrs all up). i assume it has crashed and will force close the program.
Reply
Report
0
0
nealF
nealF     nealF
This comment was minimized by the moderator on the site
ok just tried a 35C8 and it took just over 90mins, so maybe 44C8 takes 11.5hrs.
Reply
Report
0
0
Gabbo
Gabbo
This comment was minimized by the moderator on the site
È possibile escludere delle combinazioni da quelle trovate ?
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations