Skip to main content

Faigh go héasca gach teaglaim atá cothrom le suim áirithe in Excel

Údar: Siluvia Athraithe Deiridh: 2020-08-24

Kutools le haghaidh Excel

Treisíonn Excel Le 300+
Gnéithe cumhachtacha

Ag ceapadh, tá liosta uimhreacha ann (slánuimhreacha, deachúil nó uimhreacha diúltacha), agus anois, ba mhaith leat gach teaglaim féideartha a fháil ó na huimhreacha seo atá cothrom le suim ar leith. De ghnáth is féidir leat foirmlí, Breiseán Réitigh nó feidhm atá sainithe ag an Úsáideoir a úsáid chun é a bhaint amach, ach tógann sé am agus ní furasta é a láimhseáil. Seo leis an úsáideach Déan Uimhir fóntais de Kutools le haghaidh Excel, ní raibh sé chomh furasta riamh in Excel na teaglamaí uile atá cothrom le suim áirithe a fháil.

Faigh na teaglamaí uile atá comhionann le suim ar leith


Faigh na teaglamaí uile atá comhionann le suim ar leith

Mar a thaispeántar an pictiúr thíos, chun gach teaglaim féideartha d’uimhreacha i raon B3: B11 atá cothrom le 520 a fháil, is féidir leat triail a bhaint as an bhfóntas Make Up a Number mar a leanas.

1. cliceáil Kutools > Ábhar > Déan Uimhir.

lámhaigh déan suas uimhir 03

2. Sa Déan suas uimhir bosca dialóige, déan na socruithe thíos le do thoil.

  • sa Sonraí Foinse bosca, roghnaigh liosta na n-uimhreacha le fáil amach cé na huimhreacha a chuireann suas le 520;
  • sa Roghanna alt, cuir 520 isteach sa Suim Bosca téacs;
  • Cliceáil ar an OK cnaipe. Féach an pictiúr:

3. Sa chéad cheann eile Déan suas uimhir bosca dialóige, roghnaigh cill chun na teaglamaí a aschur agus cliceáil ar an OK cnaipe. Ansin a Kutools le haghaidh Excel tagann dialóg suas chun a insint duit cé mhéad teaglaim a chruthófar, cliceáil OK.

Is féidir leat a fheiceáil go bhfuil gach teaglaim féideartha d’uimhreacha roghnaithe arb ionann iad agus 520 liostaithe mar seo a leanas.

nótaí:

1. Tá sé roghnach líon na gcomhcheangail agus líon na n-eilimintí i ngach teaglaim a shonrú in ionad gach teaglaim a ghiniúint. Mar a thaispeántar an pictiúr thíos, is féidir leat líon na gcomhcheangail a shonrú mar 4, agus líon na n-eilimintí i ngach teaglaim a shonrú ó 1 go 4, ansin, gheobhaidh tú an toradh seo a leanas:

Toradh:

2. Is féidir an ghné chumhachtach seo a chur i bhfeidhm ar uimhreacha deachúlacha agus diúltacha, féach an scáileán:

Agus gheobhaidh tú an toradh mar atá thíos ar an scáileán a thaispeántar:

3. Is féidir leat an Sábháil i mbileog nua bosca chun na teaglamaí a aschur go bileog nua.


Faigh na teaglamaí uile atá comhionann le suim ar leith

Kutools le haghaidh Excel Cuimsíonn sé níos mó ná 300 uirlis áisiúil Excel. Saor chun triail a dhéanamh gan aon teorannú i 30 lá. Íoslódáil an triail saor in aisce anois!


Uirlisí Táirgiúlachta Molta
Féadann na huirlisí seo a leanas do chuid ama agus airgid a shábháil go mór, cé acu ceann atá ceart duitse?
Cluaisín Oifige: Cluaisíní úsáideacha a úsáid i d’Oifig, mar bhealach Chrome, Firefox agus New Internet Explorer.
Kutools le haghaidh Excel: Níos mó ná 300 Ardfheidhmeanna le haghaidh Excel 2021, 2019, 2016, 2013, 2010, 2007 agus Oifig 365.

Kutools le haghaidh Excel

Níl san fheidhmiúlacht a thuairiscítear thuas ach ceann de 300 feidhm chumhachtach atá ag Kutools le haghaidh Excel.

Deartha do Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 agus Office 365. Íoslódáil agus úsáid saor in aisce ar feadh 30 lá.

Scáileán de Kutools le haghaidh Excel

btn léamh níos mó      btn íoslódáil     ceannach btn

Comments (19)
No ratings yet. Be the first to rate!
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!
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.
This comment was minimized by the moderator on the site
I do not know about others, but I still have it.
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?
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
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?
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.
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*.
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!
This comment was minimized by the moderator on the site
Was the bug fixed? What was great? Thank you.
This comment was minimized by the moderator on the site
This is so great, Thanks
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.
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 ?
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

This comment was minimized by the moderator on the site
I'm having this problem! Did you get it to work?
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.
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.
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.
This comment was minimized by the moderator on the site
È possibile escludere delle combinazioni da quelle trovate ?
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations